best way of importing data into mysql

Question

i have a table with 500,000 rows and about 10 columns that is in access

how do i import it into mysql?

Answer 1

Here's a writeup on the subject.

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

This outlines 3 strategies to accomplish your task of migrating to MySQL

• Telling Microsoft Access to Export Its Own Tables
• Converters That Generate Intermediate Files (i.e. CSV)
• Converters That Perform Direct Data Transfer

Also, some Forum Discussion on the issue.

And finally, software exists (Access MySQL Import, Export & Convert) that might do the trick also. Note: I've never used this so I really don't know how good it works, I just added it for completeness.

As you can see, there are several ways to accomplish this, I recommend checking out each one and choosing the one that works best for you.

Answer 2

See:

Access2MySQL

Answer 3

dump to csv and import csv using mysqlimport is another option.

Answer 4

Try SQL Data Examiner

Answer 5

MySQL offers an article, Migrating from Microsoft SQL Server and Access to MySQL, and migration forums.