MySQL to Access database conversion

Initial screen shows you that Full Convert will automatically detect your database if you don"t know which one do you have. Of course, if you do know your database, do select it from the list on the left.

We will choose MySQL from the source database engines list. As our MySQL server is on the local machine and we have full privileges, we will simply choose a database from the dropdown menu.

List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.

We will choose Access database from the list of available source database formats and fill in connection properties. You can simply click ellipsis (...) button to select MDB or ACCDB database file. It depends on the version of your database. Access 2007 databases are contained in ACCDB files, while earlier versions are contained in MDB files.

If your Access database is protected, fill-in your password as well.

In case you use Access workgroups and security, you will need to also find your system database and specify username/password for it.

We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don"t need - or deselect all, then select just the tables you do need.

Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.

Click the Convert! button to get started.