将Ms访问数据导入MySql [英] import Ms access data into MySql

问题描述

大家好我如何将Ms Access数据导入MySql谢谢

hello everyone how can i import Ms Access data into MySql thank you

推荐答案

Checkout MySQL 迁移工具包。

Checkout MySQL migration toolkit.

我有一种独特的感觉，即用于Access的MySQL迁移工具包不是免费的（但我可能是错的）。


另一种解决方案是自己动手。

编写服务器应用程序（如PHP）从Access数据库读取表和数据并将其存储到MySQL数据库中。

使用像Adodb这样的（免费）工具使其相对容易。


Holler当你需要更多信息时。


Ronald

I have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).

Another solution would be to do it yourself.
Write a server application (like PHP) that reads the tables and data from the Access database and stores it into the MySQL database.
Using a (free) tool like Adodb makes it relatively easy to do.

Holler when you need more info.

Ronald

你好大家怎么能我将Ms数据导入MySql谢谢

hello everyone how can i import Ms Access data into MySql thank you

首先将表从MS-Access导出到文本文件然后使用inf ile命令将该文本文件导入MySQL。

这是一个infile命令的例子：


LOAD DATA INFILE？name_of_exported_file.txt？

INTO TABLE table_name

FIELDS TERMINATED BY？，？

LINES终止于？\\ nn ;;

First export the tables from MS-Access into a text file and then use infile command to import that text file into MySQL.
Here is an example of infile command:

LOAD DATA INFILE ?name_of_exported_file.txt?
INTO TABLE table_name
FIELDS TERMINATED BY ?,?
LINES TERMINATED BY ?\r\n?;

这篇关于将Ms访问数据导入MySql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！