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?
Axxmasterr
Posted 2009-08-10T18:48:01.303
Reputation: 7 584
What is the best way to convert a MySQL database to an access database?
Answers
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
Cristian Ivascu
Posted 2009-08-10T18:48:01.303
Reputation: 202
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 – 2009-12-23T20:45:36.367
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.
David W. Fenton
Posted 2009-08-10T18:48:01.303
Reputation: 984
1
There are Many programs that can do it. dbload is an example. I haven't found any database converter freeware yet.
xxl3ww
Posted 2009-08-10T18:48:01.303
Reputation: 1 489
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.
to an access db? – Troggy – 2009-08-10T18:52:10.623