To export an access database ( mda file) to MySQL database is quiet easy. All needed is to download 32 bit MySQL Connector/ODBC driver from http://dev.mysql.com/downloads/connector/odbc/ and follow steps below. 1- Select the table to export. 2- From External Data tab select ODBC Database . See picture below. Picture 1 ODBC Database Export 3- Specify table name to export onto. Typically the same name as the access table name. 4- From Select Data Source dialog select Machine Data Source tab and click new. Picture 2 MySql OBDC Driver 5- Select MySQL Connector/ODBC driver from list. Click OK. 6- Specify co...
Software Engineering experiences and best practices