Re: Know any good scripts to convert msaccess to mysql

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.