Re: converting access db to mysql

You might want to consider exporting the data from Access to a flat text file. then import the flat text file into mysql. This way, you can avoid having to find a way to convert directly from one to the other.

I know mysql can import flat files, as a co-worked did it to load legacy data from our operational system into a mysql db for a web page.
hth
Rob

chicha <mario_at_blindsight.org> wrote in message news:<chcfuv$n00$1_at_bagan.srce.hr>...
> Hey people,
>
> I have to convert MS Access 2000 database into mysql database, the whole
> thing being part of this project I'm doing for one of my faculty
> classes. My professor somehow presumed I knew db's and gave me long list
> of things to do with that particular database, first thing being that
> particular conversion. Truth is that I don't know a first thing about
> db's, let alone using mysql... I downloaded mysql form www.mysql.com and
> still searching for MS Access 2000 (it doesn't work with 2003 I have,
> or I don't know how to make it work).
>
> Any kind of help will be welcomed and highly appreciated!!!
>
> Thanks,
>
> Mario
Received on Sat Sep 04 2004 - 20:09:46 CEST