Hi Chris

I agree that what you say that it would work

with the

if RTRIM(@columnname1) = 'softwaremanufacturer' and RTRIM(@columnname2) = 'productname'

begin

UPDATE dbsource SET

softwaremanufacturer = dbref.Amended_SW_Manufacturer,

but what if the softwaremanufacturer from the spreadsheet was called, softwareman or productmanufacturer or just manufacturer as it could be named anything but there will only ever be one column that matches the softwaremanufacturer column

regards

Alan