Export MySQL to Access for free...

April 3, 2008 6:40 AM

What is the easiest (and free) method of exporting a MySQL database and getting it (intact) into Access ?

We have a DB of stuff in MySQL. That's all peachy and nice, but we want to give a copy of our DB to a customer, and they only do Access. Presumably, I would have to send them a .MDB file with the data intact. (if this is incorrect, let me know - I do networking for a living, not DB stuff).

The guy who does the DB stuff is on vacation, and the customer wants this before he gets back, so it's to me (and you!). Thanks in advance!

posted by Pogo_Fuzzybutt to Computers & Internet (3 answers total)

Best answer: There might be an easier way to do it, but you could always use MyODBC. The long and short is that you'll install MyODBC, create a DSN that points to your MySQL database, and then use Access to import the tables into a new Access Database.
posted by uncleozzy at 6:48 AM on April 3, 2008

Hmm, ODBC is a good answer. If you have no network access between you, then you could perhaps "create table foo as select *... engine=csv" in mysql and mail them a copy the resulting CSV file in the database data directory.
posted by cmiller at 7:10 AM on April 3, 2008

Response by poster:
Thanks Uncleozzy, that worked great.
posted by Pogo_Fuzzybutt at 7:23 AM on April 3, 2008