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

Thursday, September 28, 2017

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.

SystemOut