How migrate MS ACCESS database to MySQL?

[radjiv]

Hi all,

I would like to migrate a MS ACCESS database with many tables and data to MySQL. Also some data in this MS ACCESS database will updated in future and I need to migrate these changes to MySQL too. Are there any programs to do this job?

Your help is great appreciated,
Radjiv

 

[jzwp22]

I'm not sure what version of Access you are using, but in Access 2000-2003, I believe there was the Upsizing Wizard that did the job of migrating your Access tables to SQL Server. In Access 2007/2010, look at Database Tools-->Move Data; there is an icon for SQL Server.

 

[foleg]

Take a look at convert-in.com/acc2sql.htm

It can either migrate MS Access data into new MySQL database or synchronize existing databases.

 

[budzprog]

try to search for software that will convert ms access database to mysql database...