Sql

RPA Discussions
1

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
2

Hey @guptasweb

  1. Read the Excel

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

Thanks
#nK

3

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.

Regards
Gokul