MS Access to MySQL is a tool to Convert, Migrate data from / to MS Access Database to MySQL or from MySQL to MS Access Database. You can convert multiple tables in one go from MS Access to MySQL or from MySQL to MS Access database.
Features: MS Access to MySQL is a conversion & migration tool for data between MS Access database tables and MySQL database tables. It is possible to convert multiple tables of data from one database to the other. You can map target database columns to matching database columns in the target table. If necessary you can filter/choose rows of data by the stating a WHERE condition. The MS Access to MySQL Loader has a built in scheduler. You can thus automate scheduled transfers between the two databases thereby easing your administrative burden substantially.
A log file records the actions that happened, happened ok or if there were any problems etc. A command line interface also is provided. If you want to you can integrate the functionality of the loader into an application of your own. The program is wizard based and can save current session parameters for recurring future use. All the sessions are stored in a repository. The Loader provides a user friendly interface to manage repository. Taking backup and/or restore repository from a previous backup is easily done. You can also create a new blank repository in case you need it. Data types are automatically checked, but you can change the destination data type specifically if you need to.
Overall: Useful utility if you use the two databases frequently.