DSXchange

Cool! I tried using this

UPDATE table SET a = :1, b = :2, c = :3, d = :4, e = :5 WHERE a = :1

and it worked fine , it is doing the update now....thanks for your help

Thanks for the welcome DSGuru2b, There is a key column in the table but it is not there in the spread sheet. So I can't use it for the update. Ray, I tried speicfying the column to be updated as a key column, The update statement is like this: UPDATE table SET a = :1, b = :2, c = :3, d = :4, e = :5 ...

Hi All, I have a spreadsheet that contains five columns a, b, c, d, e. The same five columns belong to a table. Column 'a' has a value set to 'x' in the spreasheet. I have to update the column 'a' values in the table as per the spreadsheet. All five columns are not the key columns. Please help me ou...