Find Solutions > MySQL

How to export an MSAccess database to MySQL:

  1. Download and install the MySQL ODBC driver
    Download the driver at http://dev.mysql.com/downloads/connector/odbc/3.51.html
    Documentation for the driver at http://dev.mysql.com/doc/refman/5.0/en/myodbc-connector.html
    Description at http://www.mysql.com/products/connector/odbc/
  2. In MySQL: create the database
    At the mysql command line, or phpmyadmin, (or whatever client you like).
  3. In MSAccess: table view
    1. select the table[s] you want to export
    2. File -> Export -> ODBC database
    3. select "Machine Data Source"
      (? sorry my notes are a little fuzzy here)
      At this point, the first time you export from MSAccess, you go to "Make New" and select the driver. Give info for your MySQL database, such as username and password.
    4. MSAccess will then silently create the tables with data in the MySQL database.

msacces_to_mysql-export_howto.html
Revised 11 February 2007