Practice Sharing: Access database import MySQL database

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

As programmers often have to do different database import and export work, this is to save data entry time. Let me share with you how to import data from an Access database into a MySQL database.

First of all, to explain the idea, you can import a number of MySQL methods, but do not package access to import directly, there are many online introduction csv format into MySQL, but the operation is very inconvenient, often error and cannot be imported. SQL Statement Import is the simplest. Is there a way to convert an Access database into a SQL statement? The focus of this article is that with the "DB2mysql.exe" tool, you can easily convert an Access database into a "INSERT into table" SQL statement in a sentence. Production of SQL statements, that is, directly copy the statement paste to phpMyAdmin total, run it.

Below is a screenshot of the software operation.

is not very simple, but there is a point to note that the data imported through Db2mysql does not support Chinese, Chinese will become a number. How to solve this problem the author is thinking about practice, if the vast number of readers have a good convenient to welcome the message exchange! This article for webmaster Nets First, reproduced please keep www.678baidu.com, thank you.