Update Maximo Table Data using insert/update statements from the Excel Sheet into Oracle/SQL Server

If you want to update Maximo tables data with the new data from XLS sheet you can insert a new column in XLS

Lets say new column P

then in the formula bar use this formula if you want to generate  Update sql statements in the P column

= "update location set glaccount = '" & M1& "'  where location = '" & B1& "'"

Now if you want to generate multiple update statement in the complete P column just highlight and enter Ctrl+Enter

You will get a list of SQL statements, copy paste and run on Target Database.