I was updating the values of columns to 0.00 using below query
update table name set column name = '0.00'
Depending on the number of rows affected you could try something like putting the following formula in cell
C2 of your Excel table:
="UPDATE tbl_name SET col_name=" & B2 & " WHERE id=" & A2
assuming that in your Excel table the
ids for each record can be found in column
A and the original values in column
B. If you then copy the formula down until you have the whole table covered you should end up with a command batch of
UPDATE commands which you should check carefully at first and then possibly apply on your database to revover the old values.