Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

Post removed (X-No-Archive: yes)

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

Gregory Nickoloff wrote:
> 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?

Go to www.mysql.com and check their list of 3rd party software, I have seen
stuff to emigrate from access to mysql.

--

//Aho

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

Post removed (X-No-Archive: yes)

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

"Gregory Nickoloff" 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

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

Post removed (X-No-Archive: yes)

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

"Gregory Nickoloff" 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?

I've been using DBACentral from MicroOLAP. It has an import function that
can attach to access (and a lot more). Try the demo version.

Best regards, Hans

Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

Hi,

use the MySQL Migration Tool.
http://www.mysql.com/products/tools/migration-toolkit/

There is also a video how to migrate an Access DB to MySQL.
http://www.mysql.com/products/tools/migration-toolkit/tutori als/AccessMigrationTutorial.html



"Gregory Nickoloff" schrieb im Newsbeitrag
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?