Convert MS Access to MySQL database using PHP script

Hi all.

I have database in MS Access.
I want to convert the database to MySQL.
I have surfed the net that there are several ways to migrate data from Access to MySql, and the easiest is to buy a piece of software.
And, other than that, we can use the MySQL odbc driver.

I just wanna know, if there are any other way like using some script, example PHP script to convert the database?

Can anyone here tell me the tutorial site that teach how to convert using PHP script ? or any other script that can do so?

Unless it needs to be done through a web interface it doesn't really make sense to use PHP for this, but still. You could basically run through every table, every record, using the Access ODBC driver, and output it to MySQL.

I think, from your post, that you're open to possibilities other than writing a php script for it. For one, the way I've done it before is to export from Access, into text files, then loading the text files into MySql using LOAD DATA.

mendhak,

Can you teach me how to use the LOAD DATA ?
Or, you can give me the link for the tutorial site.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Ever used MySQL Migration Toolkit?

You would be best off connecting to the mysql server using Access and running a query from the access database.

Mysql comes with an ODBC driver which you can use from access to make a connection.

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Take a look at this pages it may solve your problem for a tool to migrate database.

From Here : http://www.dbload.com

If you are using phpmyadmin with your MYSQL program, I will advice you take a look at the link below. I had a problem loading data into MYSQL before. But now I am confident with it and I do it easily. Thanks to the help I got from some 'pros' here recently. Some of the advice I got have also been mentioned to you here already.

This is the link for the post.
http://www.vbforums.com/showthread.php?t=603702

Menre