Question

SQL server 导入excel错误

Answer 1

先把execl导入到一个临时表，
select
*
into
[表]
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel
5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)
再从临时表转移过去数据
insert
tablename
([field1],....)select
[field1],....
from
[表];
drop
table
[表];