Archive for category Database

Note: The following guide was tested on WindowsXP, MS-Access 2007, Mysql ODBC connector 5.1

Prerequisites: Mysql and MS-Access installed in your localhost

Sometimes could happens that we are not familiar with some tools, in this case I was not familiar with MS-Access and I needed to export a table I need from Access to Mysql.

There are several tools which allow you to export from Access to Mysql but there is a very simple procedure you can perform to solve this issue very quickly using the ODBC driver.

So the first thing to do is to download the mysql connector from http://dev.mysql.com/downloads/connector/odbc/5.1.html accordingly with your OS.

After the install click start -> run and load the following command: control admintools; run Data Sources (ODBC) to set up your mysql database connection.

Under ‘User DSN’ tab click the ‘add’ button:

• select the MYSQL ODBC (version of the connector) Driver
• Edit the connection parameters to connect through ODBC driver to your database

If all worked pressing the ‘test’ button will confirm if the configuration settings are correct.

Open your mdb file with MS-Access:

• Right click on the table you want to export to mysql
• In the contextual menu selet the ‘export’ -> ‘ODBC Database’ option
• A new Export window will appear telling you the name of the table you want to export; press the ok button
• In the new window ‘Select Data Source’, select the ‘Machine Data Source’ and select the Mysql Database profile you created in the first steps of this guide to  finish the import procedure.

After these commands, the database you selected in the last step of this guide, will be populated with the table selected.