Importing an Access DB to mySQL

Absolute noob question on mysql

[Jakotsu]

I have a control panel with MySQL 4.0.27-standard and phpMyAdmin 2.8.0.2. I have also an Access database (MDB) and the question is if I can import that database into the server somehow.

There is an Import tab at the control panel which provides a feature to import a text file, but I have no idea what format should the file be in.

Any help on this is really appreciated, I would post a screenshot of the MySQL control panel but the forums admin would delete this topic if I do so.

[txbakers]

I always exported from Access to Text, then imported the text file. It was an extra step, but it was cleaner that way.

[FalseDawn]

I would also export from Access to text and then import - or write a VBA script in Access to create the appropriate mysql create/insert etc statements and output those to a file and run directly in PHPMyAdmin.

You might also want to look at some of these tools:
[google.com...]

[Jakotsu]

OK, but before importing the CSV file, should I create all the tables or they'll be created automatically when importing the CSV file?

[FalseDawn]

No, you'll either need to create the tables manually or use a tool to map Access's field types to MySQL field types and spit out the appropriate "CREATE TABLE" SQL that you can run in PHPMyAdmin to create the tables.

Don't forget - you will also need to create the MySQL database and assign a user and permissions as well.

[craigedmonds]

Another way is to install the MySql driver for Windows on your windows machine and then create an odbc connection in Access and export the data from access to mysql.

[edited by: rogerd at 6:13 pm (utc) on Nov. 7, 2006]
[edit reason] No links/URLs, please. [/edit]