Posted by Tom on 05/23/07 17:18

On Sat, 12 May 2007 01:42:45 GMT, 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?

I'm not familiar with Access myself, but if you can same files like you would in
Excel, you might be able to save your databases information in tab delimited
files, then create PHP script to read those files an populate your MySQL
database.

I'd also check the MySQL site to see if they have a utility there. I'd bet other
people have had to do the same thing already and may save you time using
something that was already built for that purpose.

Tom
--
Newsguy.com - Unlimited Accounts
Increased to 32 concurrent connections

[Back to original message]