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.

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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.