Tutorial for migrating data from MS Access to MySQL - 中国站长下载,源码下载,站长工具下载

one of the main reasons i started freesql.org is to open up newbie users to the wide world of enterprise-level database access. one of the most common questions i'm asked is "how do i upload my data from my access database to my mysql database?" this is far easier than you think and is done using an often overlooked feature of microsoft access. namely, the ability to import, export, and link to non-access data sources. for now lets just consider mysql.
the first step is to provide the capability for your windows system to communicate with the remote mysql server. this is done using myodbc. if you don't have it installed already, get it from here.
recently i had to move a database of zipcodes to my mysql server. i will list the steps i took to migrate this data.

in the windows 98 control panel (or equivalent in winme, windows 2000, or xp) open the odbc data source administrator. you will want to create a new system data source.
choose "add", then select the mysql driver. you should see the following form. give it a meaningful dsn name, in my case i called it remotezipcodes. the dsn is how you will identify this connection when you want to use it from another application. fill in the rest of the necessary information correctly. one tip, mysql is case sensistive. make sure you get the username, password, and database case correct.
here is my source data. a single access table containing zipcodes by city and state, along with their latitude and longitude.
we want to "export" our data to the remote mysql server. select the table you want to export and choose "file/save as/export…" from the main access menu, then choose "to an external file or database".
the "save table" dialog box will then open and by default will try to export your table to another access mdb. you change the format of the destination by choosing from the "save as type" combo box. in our case we want to select "odbc databases ()". it is probably at the very bottom of the list.

next, this little window will open

to allow you to change the name of the table that will be created in the remote database.
when you select "ok" you should then see your list of odbc data sources. select the dsn you created in step 2.
once you select the data source, the export begins immediately. be patient, it may take a while, but it does work!

try experimenting with importing and especially linking too! you will find that you can read and actually query data from oracle, postgresql (my other favorite database), excel spreadsheets, and even text files. to link a table into an access mdb, on the table tab select "new" then "link"....i think you'll figure out the rest!
　　 mysql

[] [返回上一页] [打印] [收藏]

上一篇文章：把access数据倒换为mysql形式

下一篇文章：一个访问ACCESS的类

∷相关文章评论∷　　　（评论内容只代表网友观点，与本站立场无关！） [更多评论...]

软件：	ASP 源码 \| .NET源码 \| PHP 源码 \| JSP 源码 \| CGI 源码 \| 网页模板 \| 网页素材 \| 字体下载 \| 工具软件 \| 服务器类 \| 书籍教程
文章：	网页编程 \| 网页制作 \| 数据库区 \| 服务器区 \| 网络安全 \| 网站运营 \| 图形图象