You are here: Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)?? « PHP SQL « IT news, forums, messages
Re: Convert Access DB to MySQL (Quick and Easy...maybe even painlessly)??

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация