how to Update sql table from collection data in one go?

harish17

Active Member
#1
Hi,

I have a collection which has 500 rows and want to update this data in to a table in sql . I was aware I can update row by row by looping each one is there a way I can update all the data in the collection in one go from Blue prism Process to sql table?

If it is calling

Thanks
 

SaJ

New Member
#2
hi,

You can achieve this by OLEDB.
Copy the collection values into excel, create the connection string to consider excel as database and sheet as table. Then execute the query.

Thanks,
SaJ
 
Last edited:
Top