MySQL数据库转移，access，sql server 转 MySQL 的图文教程

            ODBC是一种让各种数据库具有相同界面的应用程序界面
先到php爱好者站的
[color=]http://www.phpfans.net/download.php?cid=1&page=3
下载mysql odbc driver。目前最新版本为v5
由于版本5容易出现乱码问题，强烈要求用版本 3.51
/*
作者:我不是鱼
网址:
[color=]http://www.phpfans.net

博客:
[color=]http://www.phpfans.net/space/index.php/2

email:deng5765@163.com
qq:245821218
*/
安装mysql odbc driver。。。
1。先用phpmyadmin建一个test的数据库，目前没用任何数据表在其中
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215002155.jpg');}" src="http://files.jb51.net/upload/20070902215002155.jpg" onload="if(this.width>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.打开[控制面板][管理工具]双击[数据库(ODBC)]
   选取[系统数据源]标签，再点击[添加]
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215003874.jpg');}" src="http://files.jb51.net/upload/20070902215003874.jpg" onload="if(this.width>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>
更多文章 php爱好者站
[color=]http://www.phpfans.net

3。打开一个access数据库
  (1)选择一个表，导出。。。
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215003280.jpg');}" src="http://files.jb51.net/upload/20070902215003280.jpg" onload="if(this.width>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)选择[odbc数据库]
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215003353.jpg');}" src="http://files.jb51.net/upload/20070902215003353.jpg" onload="if(this.width>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。选取[机器数据源]标签，选择我们之前设置的dwmxphp然后[确定]
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215003157.jpg');}" src="http://files.jb51.net/upload/20070902215003157.jpg" onload="if(this.width>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。执行完成后打开phpmyadmin看看。。没错，那就是我们刚才导入的数据
[I]screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/upload/20070902215004456.jpg');}" src="http://files.jb51.net/upload/20070902215004456.jpg" onload="if(this.width>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>
            
            
您可能感兴趣的文章:

找到一种不错的从SQLServer转成Mysql数据库的方法

Navicat异地自动备份MySQL方法详解(图文)

Mysql安装 Navicat 出现1044/1045错误的解决方法

navicat无法远程连接mysql的解决方法

简单实现SQLServer转MYSQL的方法

使用mss2sql工具将SqlServer转换为Mysql全记录

Navicat for MySQL 乱码问题解决方法

使用Navicat Premium将SQLServer数据导出为sql格式

Navicat远程连接SQL Server并转换成MySQL步骤详解