Skip to main content

Posts

Showing posts with the label mda file

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 co...