2

I need to convert databases both directions and I also need to grab subsets of data on occasion. Is there an easy way to do this?

1
  • to an access db? – Troggy Aug 10 '09 at 18:52
5

Exporting to CSV from MySQL and import it in Access might do the trick ... use MySQL GUI package for the mysql part; access should know how to do this

1
  • Just use ODBC, then you can switch from import/export to linking in the future. Going through CSV is a major pain, even with the 2007 improvement of 'saved imports'. – atroon Dec 23 '09 at 20:45
2

Set up a DSN for your MySQL database.

To import, choose GET EXTERNAL DATA | IMPORT from the FILE menu.

Pick ODBC and then the DSN as your data source, and choose the tables you want to import.

To export, choose EXPORT from the FILE menu, point to the DSN for your empty MySQL database and choose the tables you want to export from Access to MySQL.

My answer assumes, based on your asking about exporting and importing, that these are one-way operations.

1

There are Many programs that can do it. dbload is an example. I haven't found any database converter freeware yet.

1

Do not import MySQL if you want to repeat operations live.

Rather link to MySQL Tables, then create make-table queries to create access tables with data from MySQL Tables.

Later, if you need to refresh in one way or the other, make deletes, add, update queries from Access to MySQL and conversely.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.