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

Source: Internet
Author: User
Tags microsoft access database

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.