UPDATE 表名
SET 表名.表中修改列=b.Excel中替换列
FROM OpenDataSource('Microsoft.JET.OLEDB.4.0','Data Source="D:\目标Excel.xls";Extended properties=Excel 5.0')...[Sheet1$] b
WHERE 表名.标识列= b.标识列
转载于:https://www.cnblogs.com/raysbo/archive/2010/01/05/1639523.html