insert into CustAppendant0001600084(vieworder,employeeid,cust2093,cust2092,dateinfo) select '1',employees.employeeid,b.number,b.consumefee,b.[date] from
OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;database=c:\111.xls;','select * from [123$]') as b inner join employees on b.number=employees.number
OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;database=c:\111.xls;','select * from [123$]') as b inner join employees on b.number=employees.number
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货