Graphic tutorials on MySQL database transfer, access, and SQL Server to MySQL

Source: Internet
Author: User
Tags mysql odbc driver

ODBC is an application that allows various databases to have the same interface. ProgramInterface

First to PhP fans station http://www.phpfans.net/download.php? Cid = 1 & page = 3 download MySQL ODBC driver. The latest version is V5.
Because version 5 is prone to garbled characters, version 3.51 is strongly required.

/*
Author: I am not a fish
Web: http://www.phpfans.net
Blog: http://www.phpfans.net/space/index.php/2
Email: deng5765@163.com
QQ: 245821218
*/

Install the MySQL ODBC driver...

1. Use phpMyAdmin to create a test database. Currently, no data tables are used in the database.

2. Open [control panel] [Administrative Tools] and double-click [database (ODBC)]
Select the [System Data Source] tag and click [add].

MoreArticlePHP fans station http://www.phpfans.net

3. Open an Access database
(1) Select a table and export it...

(2) select [ODBC database]

4. Select the [machine data source] tag, select the previously set dwmxphp, and then [OK]

5. After the execution is complete, open phpMyAdmin .. That's the data we just imported.

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.