Great Tool for converting MS Access to MySQL
For two projects that I’m busy with, I need to convert an Access database to MySQL. Its more the data that needs to be transferred thanthe structure.
Going through the web, I found a great tool for doing this, and best of all its freeware!
DB Converter by Zenwerx Custom Programming takes an Access database, and generates it into SQL compatible with MySQL and Oracle. Fab tool, andworks, and gets my thumbs up.
Have a look at: http://www.zenwerx.com/products.php?id=2
The download is available at: http://www.zenwerx.com/dbc_1.5.2_install.zip

mmaxx
Form access you could also just save as the db and select ODBC and a MYSQL connection. Access will do all the work for you.