http://blog.csdn.net/diyoosjtu/article/details/7573620
首先,创建一个表:
- create table aaa(name varchar(10),user_id varchar(20));
create table aaa(name varchar(10),user_id varchar(20));
然后插入数值:
注意要转换Excel中的数据类型
- insert into aaa(name)
- select cast(保管人 as varchar(10))
- FROM openrowset( 'Microsoft.Jet.OLEDB.4.0',
- 'EXCEL 8.0;HDR=YES;IMEX=1; DATABASE=C:\Users\admin\Desktop\database\datasheet.xls',总表$)
insert into aaa(name)
select cast(保管人 as varchar(10))
FROM openrowset( 'Microsoft.Jet.OLEDB.4.0',
'EXCEL 8.0;HDR=YES;IMEX=1; DATABASE=C:\Users\admin\Desktop\database\datasheet.xls',总表$)
其中,总表$是sheet名,保管人是列名。