.mdb or xml to mysql

[aggelos]

Hello, i have an MS access db file and i want to import the tables of this database to a mysql database. I have also seen that i can export from MS Access to xml file.

How can i import into mysql, a .mdb or a xml file?

[rcbasie]

Hi.

You can do this with access and an ODBC driver. Do the following steps:

1) Download and install the MyODBC driver.
2) Set up a connection for the odbc driver (i use system DSN, go control pannel->administrative tools->odbc data sources->system DSN).
3)Make sure you have set up the MySQL database the the MyODBC connection is pointing to.
4)Open the .mdb file in Access.
5)For each table, right click, then select 'export'->to external file....->'save as type ODBC data sources', then select your newly set up ODBC data source and click go.

You'll have to repeat step 5 for each table. If you have Visual Basic, you can write a program to automate this task using the same ODBC driver you set up. Just use ADO, and use "DSN=foobar" for your connection string.

hth
Robin