Posted by urprettyfriend on 04/04/07 13:02

On Apr 3, 11:55 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> urprettyfriend wrote:
> > 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.
>
> Import the data into a second table, then do something like this:
>
> update Table1
> set t1.c4 = t2.c4,
> t1.c5 = t2.c5,
> t1.c6 = t2.c6,
> t1.c7 = t2.c7,
> t1.c8 = t2.c8,
> t1.c9 = t2.c9,
> t1.c10 = t2.c10
> from Table1 t1
> join Table2 t2 on t1.c1 = t2.c1
> and t1.c2 = t2.c2
> and t1.c3 = t2.c3

Ed,

Thanks for ur solution. But I can't create a temp table in the db....I
already asked if I can do that, Unfortunately, I am not allowed to do
that. Please tell me if there is any other way to do this.

Thanks!

[Back to original message]