Hello,

Thanks for your replies.I have an Excel application to which I provide
data through a saved query from a table in Oracle DB.I actually pull
all the rows of a field,Roc from the table into a column in excel.

Everyday,I get a data dump from an external excel sheet containing TIN
codes.This has matches to the Roc code by lookup formulas.The matching
data is displayed in another column.My question is how do I update the
table with these new values from the new column?

Thanks,

Roy