How to quickly transfer tables in the Access database to the MySQL database ZZ

Http://blog.csdn.net/hfly2005/archive/2005/05/27/382003.aspx

Users who use PHP should be familiar with MySQL. It is basically the best choice for PHP! So how can we transfer data from the Access database to MySQL. This article helps you solve this problem!

I. Environment preparation:

1. Install the MySQL database environment.

2. Install Microsoft Access database

3. Install MySQL ODBC (the author uses the MySQLODBC-3. 51. Version 011)

4. Install phpMyAdmin (PHP support required) or other MySQL database management software.

Ii. Transfer:

1. after the installation is complete, open the control panel, choose data source (ODBC), select the file DNS tab, and click Add. In the displayed window, select MySql ODBC 3. 51 driver; click the next button. In the new window that appears, click the Browse button to select the location where you want to save the DNS file. Here we will select the default save. In the saved file name, enter test. DNS, click next, and then click Finish.

2. In the pop-up window, set some connection parameters for the MySQL database. You only need to fill in MySQL connection parameters. (1) enter the name of your MySQL server in host, for example, localhost. (2) Select the database in which you want to import access data. (3) enter the username or password used to connect to the MySQL database in user and password respectively. The following port and SQL command can be left empty. As shown in. Click OK. In this case, a test item is added to the file DNS. DNS indicates that the MySQL ODBC data source has been successfully created. Click OK.

3. open the ACCESS database file, click Export, and select the file storage type as ODBC database () in the pop-up save window. The ** (name of the table you selected) export a table to ** (name of the table imported to MySQL database) in the ODBC database dialog box, click OK, and select the test we just created in the Select data source window. DNS: Click OK to transfer the table from the Access database to the MySQL database.

4. When we use phpmyadin to browse the test database, we will find that the book table we imported already exists and all the data has been transferred!

Iii. Summary

I have discovered this by accident. I hope it will help you. I wonder if you have figured out the transfer through the above explanations. If you have any questions, please discuss it!