how to insert multiple data by bot in sql one by one from excel sheet and write the status simultaneously in the excel sheet?

1 Like

Hey @guptasweb

  1. Read the Excel

  2. Loop through each and perform SQL query for every iteration


Hi @guptasweb

Try the following

  • Read an excel file → Store the Data Table in an Variable
  • Use For Each Row in DataTable activity → Pass the Dt variable
  • Inside the For Each Row in DataTable use SQL query.