import data from excel to MS SQL using DTS

Hi guys,
I need to import data from excel to MS SQL table, but I already have data in MS SQL table, I just want to update one column.
How can I do that?There are a zillion (or is that a squintillion Rudy?) ways to do this, but I'd suggest bringing the Excel worksheet into a scratch table, then doing an update of the column in the target table, with lots of error checking added for good measure.

-PatP