Subject update statement Excel Sheet
Author Ahmad F. Sarhan
 Hey everyone,
I need your help in one of 2 questions please,


 i need to update my table with multi values , each value has its own condition
I mean
update T1 
set Col1 = Val1 where Col2 = No1
set Col1 = Val2 where Col2 = No2
set Col1 = Val3 where Col2 = No3
Set Col1 = Val 600 where Col2 = No600

and so on. I tried the simple lines as I wrote above but its not working.


I want to update my Table from excel sheet how can firebird read from excel sheet.


~{ Ahmad F. Sarhan }~ 

[Non-text portions of this message have been removed]