MySQL database transfer, access,sql server to MySQL graphics and text tutorials _php Tips

ODBC is an application interface that lets the various databases have the same interface

First to the PHP enthusiasts station http://www.phpfans.net/download.php?cid=1&page=3Download the MySQL ODBC driver. The latest version is V5
Since version 5 is prone to garbled problems, it is strongly required to use version 3.51

/*
Author: I am not a fish
Url: http://www.phpfans.net
Blog: HTTP://WWW.PHPFANS.NET/SPACE/INDEX.PHP/2
Email:deng5765@163.com
qq:245821218
*/

Install MySQL ODBC driver ...

1. Using phpMyAdmin to build a test database, there is no data table in which

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>

2. Open [Control Panel] [Admin tool] Double click [Database (ODBC)]
Select the System Data Source tab, and then click [Add]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>

More Articles PHP enthusiasts station http://www.phpfans.net

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

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>

(2) SELECT [ODBC Database]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>

4. Choose the [Machine Data Source] tab, select the dwmxphp we set before and [OK]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>

5. Open the phpMyAdmin after the execution is complete. Yes, that's the data we just imported.

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7 this.alt= ' Click here to open new Window\nctrl+mouse Wheel to zoom in/out ';} ' Border=0>