Re: How to convert an Access 2000 Database on PC to a MySQL on Unix Platform

[Oliver Vecernik]

Liqiang Feng schrieb:
> I need to convert an Access 2000 Database on PC to a MySQL database on 
> Solaris platform. What is the best way to accomplish this? Any 
> suggestions, pointers are appreciated.

You can accomplish this by using ODBC (3.51.03). Define a DNS to your 
database. Within Access choose File->Export and ODBC() as type. After 
completing the dialogs the table is created and data are transferred 
automatically.

The only drawback is to choose each table seperately. If you need this 
functionality more often, you can create a macro...


HTH,
Oliver