1,217
社区成员




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