sudhanshu9997

New Member
I will you deal with the bulk data.
You have an excel sheet with 500000 row in single sheet.
You need to ,load it in the collection in blue prism.
How will you deal with it ?
 

Navinraju

New Member
I think oledb is used to work with oracle... Not with excel data.. May be csv file deal with.. I dont know am right or wrong...
 

Udhams

New Member
I think oledb is used to work with oracle... Not with excel data.. May be csv file deal with.. I dont know am right or wrong...
Per my Automation experience, I have used excel workbook as database after Oledb connection and we use SQL queries to retrieve data from excel but here the challenge is to import the data into collection after using it as a database.
 

ivan.gordeyev

New Member
I suggest that both of you review the official documentation.
Blue Prism Excel Automation Guide.
You can also find appropriate references in a popular search engine.

Search for "Blue Prism - Guide to OLEDB v2 Pdf - Blue Prism for You" perhaps or just read it on the Blue Prism portal.
 
Top