How do you export data out of MS Access?

Question

We currently have a very small database in MS Access 2003.
Our company would like to migrate all data to MySQL.

Currently, we are having a hard time finding out, how to get our data out of Access in the first place.

Does anyone know how to perform one of the following or give us any other hint?

1) Export data to CSV-File

2) Generate:
a) CREATE TABLE statement
b) INSERT INTO... VALUES

(for an existing table with a few rows)

Any help at all greatly appreciated. Thanks in advance!

Answer 1

Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL.

Answer 2

Try this:



http://www.howtodothings.com/computers/a3744-how-to-convert-access-to-mysql.html



Please remember to take a back up of the Access Database before you start, incase it does not go well.



Oh and depending on the version of access your using depends on where the export functions sit on the menu.



If you can let me know your version I can point you in the right direction for exporting.

Answer 3

The way I did it was to get a MS Access --- converter



http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-accessprep.html













here is the one I used





http://dbconvert.com/convert-access-to-mysql-pro.php?DB=1

Answer 4

appropriate click on table you opt for to coach in excel > Export... on the backside on the 'Export table window ' chosen 'keep as sort: Microsoft Excel ninety seven-2003' and supply the Excel's report call. desire I helped you