Exporting MS Access to MySQL

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 connection parameters and click OK.

7-      Newly created data source will be added to Machine Data Source tab. Select it and click OK.

8-      Check Mysql DB and Validate that export is successfull.