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.

Thanks in advance!

• Next in forum: Re: Naming The Database Server(s)?
• Prev in forum: Re: Naming The Database Server(s)?
• Thread view: How to update selected columns of a table in SQL server db using data from a Excel file?

[Reply to this message]