Click to See Complete Forum and Search --> : Insert/Update Rows


kevinmcqueen
04-05-2006, 05:17 PM
Hi,

I have a spreadsheet that I use for updating a database, has the code in it, ie, update points set row1 = 99 where row2=1;

On another server, using the same method of copy and pasting it, if that row doesn't exist, it inserts the values into a new row.

However, on this server that is mine, when i try it, it don't insert the new row...Any ideas why?

NogDog
04-05-2006, 07:44 PM
DBMS type and version?