Reply to How to update selected columns of a table in SQL server db using data from a Excel file?
Posted by urprettyfriend on 04/03/07 19:03
Hi,
I have an Excel file with 400 rows of old values and the corresponding
new values. My table currently has 10 columns out of which 3 columns
use the old value specified in the excel file. I need to update those
old values in the columns with the new values from the Excel file.
Please guide me as to how to proceed with this.