用SQL SERVER的导入/导出功能或者在查询分析器中直接写查询语句来实现: insert into 表1 select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=F:\My Documents\资料.xls',sheet1$) go insert into 表2 select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=F:\My Documents\资料.xls',sheet2$) go ...
insert into 表1
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=F:\My Documents\资料.xls',sheet1$)
go
insert into 表2
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=F:\My Documents\资料.xls',sheet2$)
go
...