Posted by Geoff on 05/17/07 12:55

"Gregory Nickoloff" <greg@nickoloff.org> wrote in message
news:9uCdnVRHv88NhtjbnZ2dnUVZ_h2pnZ2d@buckeye-express.com...
> Anyone know of a quick and easy way to convert a MS Access DB to MySQL?
> I've
> got an ecomm site that is powered by a MS Office Database and we have to
> get
> it changed over to LAMP-based technology. I've been futzing around with
> importing the tables as .csv files and so forth, but that isn't such a
> great
> solution. Are there any scripts out there that will do it?

try this

install mysql ODBC connecter in windows and setup a connection to mysql
go in ms access, select tables and export to odbc

thats it
it doesn't make good field types, but it ain't too bad

[Back to original message]