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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

puppydogbuddyCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.