excel导入sql

 select * from openrowset('MicroSoft.Jet.OleDB.4.0','Excel 5.0;HDR=yes;Database=c:/111.xls',sheet1$)

在C盘下一excel文件：111.xls。sheet1。

注意：excel文档应关闭。

---

批量关闭：

declare @sc_nbr varchar(20),@sc_lot varchar(20)

declare cur_1 cursor local static scroll for
select * from openrowset('MicroSoft.Jet.OleDB.4.0','Excel 5.0;HDR=yes;Database=c:/11.xls',sheet3$)

open cur_1
fetch first from cur_1 into
@sc_nbr,@sc_lot
while @@fetch_status = 0

begin
update wo_mstr
set wo_status = 'C'
where wo_nbr = @sc_nbr and wo_lot = @sc_lot

fetch next from cur_1 into @sc_nbr,@sc_lot
end
close cur_1
deallocate cur_1

---