import a MySQL dump in to Access

I need to know how to import a MySQL dump file in Access.
I can't use a ODBC connection directly. So I need another way to export/import db in Access
fdg1966Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
puppydogbuddyConnect With a Mentor Commented:
The MySql.Com web site (see link below) indicates that mysqldump can also be used to generate files in CSV, other delimited text, or XML format. If that is the case you should be able to import as a csv into Access.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Here is a link that contains a tutorial for importing a csv file into access by executing ms access commands on the File menu.  If you are so inclined, you could create a button and  automate the process with a couple lines of code.
DoCmd.TransferText acImportDelim, , "tblImportData", "C:\CompleteFilePath.txt", False

For further info, look at the transfertext method in Access Help.
0
 
puppydogbuddyCommented:
forgot to give you link for tutorial on using access command menu to do the import.
      http://www.lib.umd.edu/groups/learning/handouts/importingdata.pdf             
0
 
fdg1966Author Commented:
I already try to import a csv dump file but I got a lot of error...
Sorry, I need something more easy to use: a program who do all that, who import the *.sql file with all the structure and data of the original MySql base.
Thanks anyway
0
All Courses

From novice to tech pro — start learning today.