怎么将excel中的数据快速导入到SQL中

来源：互联网发布：php程序员求职编辑：程序博客网时间：2024/04/28 05:48

首先，看一下SQL中的建表语句，因为这可能是别人给你的，得按照表来做。

接下来，我们看看给到的excel 文件

我的做法是先将excel的数据全部复制到TXT文件中。保存编码为 utf-8

然后进入MYSQL 进入库后，找到所要插入的表。如 data2

load data local infile 'D:/data1.txt' into table data2 character set utf8 fields terminated by '\t' ;

character set utf8 这个一定要加上，不然中文就是乱码的

第二种方法

character set utf8

"Telephone Number","Lname","Fname","Company","Address","Job","MobileCode","Mobile"
"13806003506","黄","佩雯",,,,"1380","6003506"
"13806003507","厦门海关缉私局",,,"1380","6003507"
"13806003508","毕","国武",,,,"1380","6003508"
"13806003509","李","丽娟",,,,"1380","6003509"
"13806003510","谢","子昱",,,,"1380","6003510"
"13806003512","杨","静婷",,,,"1380","6003512"
——————————————————————————————————.txt

bulk insert testbulkinsert
from 'd:\data.txt'
with
(
fieldterminator=',',
rowterminator='\n',
keepidentity
)

0 0