Posted by Tim Roberts on 02/01/06 09:46

laredotornado@zipmail.com wrote:
>
>I am tasked with converting an MsAccess db to a MySQL 4 db in a Linux
>environment. Can anyone recommend any good freeware/scripts to help me
>do this?

Googling for "access export sql" resulted in a MySQL hit first thing.

The conversion is rarely perfect. Be prepared for some manual
intervention. Standard practices in Access don't always line up with
standard practices in MySQL. In particular, you will want to think very
hard about any special characters in your table and field names. It's
common to use spaces and dashes in Access field names, and it is possible
to use them in MySQL, but it's inconvenient.
--
- Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.

[Back to original message]