MySQL Question for you programmers...

[galleryseek]

Is there ANYWAY to code a program, or a script..

that will take rows from an MS Access Database OR a RDBMS (Relational Database Management System) and transfer them to a MySQL Table???

I would really hate to have to enter all of the rows in by hand, seeing as to how theres approximately 6,500 of them with a bunch of columns in each.

thx

[Libertine]

Yes, and it should be fairly easy even.

[jwerd]

I can see what I can do. If you are interested, lets discuss the price and all that good stuff - [email protected]!

Thanks

[woj]

Export MsAccess data as text and then just import it into mysql.

[fuzebox]

The easiest way would be to export it in csv format, but alternatively you could write a script to do it. I did this once using libtds I think.

[crunchyinmilk]

set up a odbc connection to your mysql database (mysql odbc connector or whatever it's called off mysql.com)

link the mysql tables into ms access

do an insert query between your access table and the linked mysql table

make sure the column types are compatible. i've experienced issues going from mysql time/date into access date fields.

[galleryseek]

thx guys, i found a program that did it for me instantly.. worked perfectly.