Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
to an access db? –  Troggy Aug 10 '09 at 18:52
add comment

4 Answers

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

share|improve this answer
    
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
add comment

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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