34,838
社区成员




insert 表(fields)
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;IMEX=2;DATABASE=C:\*.xls',[sheet1$]) as aa
inner join bb
on aa.........
insert 表 select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;IMEX=2;DATABASE=C:\*.xls',[sheet1$])