1,创建跨库执行的条件
exec sp_addlinkedserver 'mydatebase','','SQLOLEDB','192.168.0.100'
exec sp_addlinkedsrvlogin 'mydatebase‘,'false',null,’sa‘,’123'
go
2,执行sql语句
insert into oaerp.oaerp.dbo.cJhDetail(DocCode,DepoID,Idx,GoodsID,Flag,Amount)
select '1015020118','0116',row_number() over(order by a.商品编码),a.商品编码,0,a.建议采购量
from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;database=D:\回春堂仓库配送品种.xls;','select * from [回春堂配送品种$]') a