Lowell (12/6/2012)

---

if you've got the linked server up and running, that's 99% of it;

the rest is just syntax.

something like this is how you update from another table...and it doesn't matter if the other table is local, linked server, etc.

aliases can help a lot here as well;

--syntactically correct, updates all rows, many to same value, most likely

UPDATE dbo.tabletoupdate

SET WHAREHOUSE = MyExcel.WHAREHOUSE

FROM ExcelDataSource...sheet1$ MyExcel

WHERE dbo.tabletoupdate.ItemID = MyExcel.ItemID

--much more explicit, only change rows that are different

UPDATE MyTargetTable

SET WHAREHOUSE = MyExcel.WHAREHOUSE

FROM dbo.tabletoupdate MyTargetTable

LEFT OUTER JOIN ExcelDataSource...sheet1$ MyExcel

ON MyTargetTable.ItemID = MyExcel.ItemID

WHERE MyTargetTable.WHAREHOUSE <> MyExcel.WHAREHOUSE