Access To MySQL    



Access To MySQL


Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL.

Using Access to MySQL

When you start the program it will run you through a wizard. The wizard will ask you all the necessary questions to setup the database transfer. In the first step you are asked to supply the file name of the Microsoft Access Database to convert.

If your Access database requires you to log in you can specify a user name, password and a system database.

Specify Access database

The destination database and MySQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database.

MySQL connection and destination settings

You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next.

Selecting the tables to transfer

Additional transfer options can be set in the dialog shown below. Here you can specify if you want to transfer the indexes of the Access database to MySQL. You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.

In both Access and MySQL fields can have default values. When creating the tables in MySQL the program can preserve the default values specified in the Access field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.

Setting advanced transfer options

After answering all the questions in the wizard you can press Finish. The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.

The settings of the wizard can be saved in a .ini file.


You can download the latest version here. After downloading the setup program you should simply run it to install the program.


I've just downloaded MS Access to MYSQL so that I can convert a small library catalogue in order to take advantage of php and MYSQL to create a flexible user interface. Your programme was so simple and intuitive that I wish I'd discovered it months ago, instead of messing around trying to set up direct interfaces with MS Access. Thank you so much!
Ruth McTighe, Barnsley Local Quaker Meeting

Version History

rss Version history RSS Feed (2017-11-07) (2017-10-27) (2016-01-05) (2015-02-09) (2014-09-24) (2013-06-24) (2012-12-19) (2012-12-18) (2012-02-28) (2011-01-12) (2010-06-10) (2010-04-16) (2010-03-08) (2009-06-23) (2009-05-16) (2008-11-28) (2008-11-10) (2008-09-23) (2008-07-26) (2008-01-15) (2007-09-02) (2007-05-10) (2007-05-07) (2006-03-19) (2005-08-30) (2005-08-27) (2005-07-28) (2005-07-27) (2005-07-26) (2005-01-22) (2004-12-12) (2004-11-20) (2004-11-19) (2004-11-12) (2004-11-09)

Additional Resources