I would like to take a MySQL database dump and then import all of the tables (the entire database) to Microsoft Access.
I've heard of the ability of Microsoft Access to connect with ODBC databases on-line, but the client's webhost does not allow external sources to access the MySQL databases...
Has anyone done this successfully (imported a MySQL dump into Access from a local SQL file)?
Thanks in advance.
Well if the table names don't change script a mysqldump --tab=placewhereyouwantthefiles for each of the tables.
Then script an access import of the tab delimited text files. That's probably the easiest way to do it.
But is there anyway to import into MSAccess from a non-delimited (CSV) data dump....
but rather from a data and structure dump
(insert into table yada yada yada)
Well you would have to create the tables and insert the data separately. Write a script to create the tables. Then create individual insert statements for each record. I'm not sure why you'd want to do this though. Maybe I'm unclear on what you are trying to do.
That's why you create a front end in Access to import the CSV. That way you control the incoming data structure and remove any possibility of user error. Create a form or macro that imports the tables from CSV. (though I tend to use tab delimited, personal preference). Then your users can just click a button and it's done.
I've done ODBC imports going the other way from MS Access to MySql without a hitch. You can download a program to do this called MySQL-Front at:
This is a Windows util that allows you to view a MySql DB, just like Access does (instead of using that very DOS-like MySql monitor).
I haven't tried using it to go from MySql to MS Access yet, but it may have just what you are looking for.