Judah McAuley wrote: > What I don't know is how to DTS to read the csv file in, stuff the > contents in a varible and then put the variable into the query, then > execute the query. I'd recommend importing the CSV to a temp table, then doing an update join: update table set X = t.field from temptable t join table d on d.id = t.id