1,216
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO t1
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'EXCEL 8.0;HDR=NO;IMEX=1; DATABASE=c:\book1.xls', Sheet1$) Rowset_1
UPDATE b
SET b.fname = a.f2, b.fstatus = a.f3
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'EXCEL 8.0;HDR=NO;IMEX=1; DATABASE=c:\book1.xls', Sheet1$) AS a INNER JOIN
t1 AS b ON a.f1 = b.fnumber
WHERE b.fstatus = 1234