Databases

[Unregistered]

How can I make ms access work with mysql?

Do I have to covert it? if so, what free tools are out there
and how to do it?

Simple rules please

[pstuart]

I'll have to check, but I believe you can export from MS Access to SQL?

Then it would be just a simple import...

Which version of MS Access are you using?

EDIT:
Opps, it looks like its a bit more complex, ODBC export is a possibility, but I'll have to figure out how that works :)

Maybe someone knows of a converter out there???

EDIT:
Try this file

http://mysqlfront.venturemedia.de/index.php

It looks like you just export to a CSV text file and use the MySQL-Front app to convert it to SQL data and then import that.

Never tried it, but looks like it should work