How to compare Excel with MSSQL in UiPath?


Can anyone help me to compare Excel data with the MSSQL Data? And Need to update MSSQL, if data missing in Database but available in Excel.

Thanks in Advance!


If you are trying to Insert a new row which is found only in excel then, then you have to use “Insert” activity.

If both Excel and DB is having the same unified id, then u can try “Bulk update activity”

Else if you trying to update the existing cells in the DB one by one, you can use "Run command " and write a update query for each value in the Excel(use a for loop)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.