Quote:
Originally Posted by Videx
There's an Access-mysql import application now? That would have saved me a ton of work. Where is that - in the Impex package I guess?
|
It's called Migration Toolkit and available from the mySQL site. Very simple to use and worked very well for me.
1. Import dB from Access or other dB to mySQL with Migration Toolkit
2. Convert with Impex to vB
If you are on a Win machine, MS also has a (free) import / convert tool that is good. It's somewhere among the SQL server tools. It imports and exports between lots of dBs. You can actually import from Access and export to mySQL in one step. Can't remember the name right now.