update table from linked Excel sheet

[vicoluf]

Like I wrote something is wrong with the statement. Do you have BBB field both in your linked server and dbo.item table?

If so try:
UPDATE a
SET a.CCC=b.CCC
FROM dbo.item a inner join XL_SERVER...sheet1$ b
On a.BBB=b.BBB
WHERE a.BBB LIKE '7%'