Convert from MS Access to MySql

[Son Nguyen]

Hi,

This might be an old topic, but now I gotta deal with it.
So how would you go about converting a MS Access file to MySQL. Currently I'm thinking of converting to CSV and then to MySql. Don't know if it seems right?

Thanks

[CyberFuture]

Just go to www.mysql.com and download the myODBC driver. This will allow you to upload your tables from Access directly to MySQL. MyODBC will also let you edit and query the mysql tables in Access. The only thing to remember is that none of your table and field names can have any spaces in mySQL.