[Powerbook]

Oooookay...
I'm in the situation to get a MySQL Database file converted into an Access file. With MySQLAdmin I can create a DB dump (e.g. in textmode) but I don't know how to import the file into Access properly!!!
Anyone done this before or found a good to-do-file?
Regards,
Powerbook

[derbs]

Pretty straightforward, i'm using access 2000, but i'm sure 97 would be similar.

Do a textdump of the db as a comma or tab delimited text file, preferably with the field names in the first row.

Now, create a new blank database in access. Go to File>Get External Data>Import , select text file as the type and locate your text file.

Now it will go into a wizard, and everything should be configured for you. The second step of the wizard will allow you to check a box "First row contains field names", so the fields will be named right. If you can't export the text file with field names in the first row, don't worry, you just have to type them in manually.

that's it! Let us know if you have any problems.

[Powerbook]

Hi Derbs!

I found the solution, since importing via whatsoever db dump didn't work! (Partly the file was missing fields, partly Access killed the structure/fields while importing).
I downloaded the ODBC connector for/from http://www.mysql.com I connected inside Access directly to the MySQL DB. This worked out!

Best regards,
PB.