This is a software that helps conversion of Access database data ti MySQL data.

AccessToMysql is a data conversion tool that helps DBA and database programmer convert Access data to MySQL database. The data transfer operation is automatic, it a visual and one-click process. You get to see a progress bar so that you are clearly aware of the time it is going to take. You can save the configuration data of a session. Whenever you need same configuration data, you are able to load the saved parameters and use it again and again. Preview lets you make sure that everything is alright before you start the conversion. The interface is easy. Select the source table from your Access database. On the destination side you should select the schema and select or deselect the fields you want to populate. Progress bar shows progress after the conversion is initiated. There is a log also available to tell you what events occurred during the process.

The conversion is possible from tables as well as queries. So conversions like table to table and query to table is easily done. Command line operation and scheduled operation lets you get the job done unattended too. While Access is a very popular database in the SME business segment it cannot keep working as your business keeps working. Beyond a size you need to graduate to business databases like MySQL or the MS SQL Server. MySQL has an advantage it is open software. The problem at the switch over is the migration of your existing data that can be large. Automatic tools like these are very handy at such times. If you have an impending switch over, you should try this out.