Insert INTO / Update Columns

[benjatado]

I am trying to insert new values into an established table. However, each time I try to do this it just appends the values at the end of the table. I need to be able to do something like the following...

Insert INTO ImageFile.HiResPath
SELECT    HiResPath
FROM         ImageDIR
WHERE ImageFile.ItemNumber = ImageDIR.ItemNumber

But this will not work... I need to make sure that I enter the correct new values within the appropriate row by ItemNumber.
Maybe Insert Into is not what I need for this??... but UPDATE wants to see a 'value' which the values only exist within an excel sheet and there are 3000 some values to be inserted.
Please help!

 

[jsteph]

You need to do something like:

UPDATE ImageFile a
SET a.HiREsPath = b.HiResPath
FROM ImageFile
INNER JOIN ImageDir b ON a.ItemNumber = b.ItemNumber
--Jim