Mysql and Access data transfer

[asmikwen]

Hello,

Being on Access, I would like to transfer some data onto Mysql. But I cannot. Is there an easy way to transfer data onto Mysql?

I am thinking that it should not be that hard to do.

Thanks for your help.

[HI2Japan]

I didnt read it but would this work?

http://www.kitebird.com/articles/access-migrate.html

and here's another
http://www.howtodothings.com/computers/a3744-how-to-convert-access-to-mysql.html

[bgkalbente]

So to transfer data from Access to Mysql, I would consider using a tool such as Datastage or Talend Open Studio.

Datastage is what we have at work and Talend is a really good alternative. You should be able to perform the migration easily. Tell us how it went.

[MeSampath]

Hi,

You can also try this way.

1. Export the tables data into .CSV files from Access db
2. Import the data into MySQL (provided tables already created) from CSV files. (using SQLYog kind of mysql browser this is easy).

Good luck