I've to convert 3 db created in access into mySql DB.
I know i can export tables as text files and then re-import them with the Sql command "load data infile.....", but there is a "little" problem: i've got 600 tables to do this!
There is a way to avoid the passage or a tool that convert access into sql?
Currently I'm using DBTools Manager Professional 2.2.0 to do the conversion. It's not 100% perfect but the data do get 100% transferred. You do have to play with the table settings after conversion to make sure they still contain what you want (ie default values may change, names of tables may change).
Another thing to note if using DBTools 2.2.0. If in Access your table names are uppercase, then when you convert it over to MySQL, the tables will be in lowercase. Make sure you check that the queries will run correctly.
All over all I give DBTools 2.2.0 nine out of ten =D
Tuan M. -- Database Developer Newbie, dot NET generation
If you want cheap-shit web hosting, check out www.websaic.com
For all your custom test socket needs, check out Gold Technologies, Inc.
Oh yeah, last but not least, GO BAR-Honda!