MS Access to MySQL Database Converter
Conversion of database with manual migration effort on a large scale is very slow and tedious tasks. Based on my own experience, I tried to write a program to convert Access databases into MySQL with Visual Basic. This program was able to convert an Access database 2003 (*.mdb) or 2007 (*.accdb), including all tables and the item records. But still limited to few data type such as text, integer and date. you can download for free here , or write an email to cool_ramdan@yahoo.com if you want the source code. please leave a comment and let me know if the program is running well.. Ps: I use vbMySqlDirect for mySQL connection and Microsoft.ACE.OLEDB.12.0 for Access Driver