Access database to Mysql

[fsmikwen]

Hello,



New on the forum so hello to all.

I am needing to perform a migration between an Access database onto Mysql. Thing is is that I do not know how to transfer the data between both databases. Is there a software solution or should I use another solution?

Thanks all!

[NTC]

from the Access perspective it is an Export of table data.....from the mySQL perspective you need to go to their forum and ask this question.

possibly you can link to the Access table from mySQL and do a one time MakeTable or AppendQuery to write the data into a mySQL table - - but fundamentally since you are going to mySQL you should seek advice in the mySQL forum

[Matrix]

This link should help: Migrating from Microsoft Access to MySQL

[WalterEgo]

using the ODBC driver you can find at http://dev.mysql.com/downloads/connector/odbc/3.51.html, you'll be able to set up a connection for mySQL that you can directly export tables to from Access.
You will need to highligh the table you want to export then..

External Data > Export > More

[Rainlover]

Many things in Access do not Export to MySQL.

Once you have migrated your Tables check things like AutoNumber. I believe you will have to reset this.