ace 读取excel

insert into T_BirdSystemSku(ID,Sku)
select ID,SKU from OpenRowSet('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;HDR=Yes;IMEX=1;Database=c:/tp.xlsx', 'select * from [工作表1$]')
where sku not in (SELECT Sku from T_BirdSystemSku)

 

可以参考：　

http://www.cnblogs.com/xiashengwang/p/3511808.html

转载于:https://www.cnblogs.com/starluck/p/5120453.html