Databases: Migrate data between MS Access DB and MYSQL

Question

I have 2 databases, one is MS Access DB from an old website, and the other one is MYSQL from the new Joomla+VirtueMart based website. I need to migrate existing products from MS Access to MYSQL.

I thought of putting both on server and writing SQL queries in MYSQL workbench, untill I have a good script for that, but I'm very new to SQL, so I'd rather avoid that.

I there a better way and more efficient for that?

Answer 1

You can always export to CSV and import that in MySQL.

Answer 2

you can use tools like Database Workbench