How to Read Bulk Data from Excel | BluePrism Tutorial | KT Sessions

#BluePrism #CodeGun #OLEDB
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video, you will learn about oledb, and read bulk data.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Contents of this video
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
00:00 ▬ Intro
00:28 ▬ Basics Of Oledb
01:20 ▬ What Is Bulk Data
03:40 ▬ Read Data With MS Excel VBO
05:01 ▬ Error While Reading Bulk Data
05:35 ▬ Limit Of Collection
06:02 ▬ System Out Of Memory
08:08 ▬ Selecting Top ''N'' Rows
10:10 ▬ Selecting Rows On Basis Of Condition
17:40 ▬ Selecting Rows Of A Range
19:57 ▬ Header Of The Collection
21:30 ▬ Use Of Dollar Sign ($) In SQL Query
23:09 ▬ Execute Two Select Queries
24:50 ▬ Logic To Read Bulk Data
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► OLEDB in Blue prism:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► BluePrism Tutorials Playlist:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► How to create First process in BluePrism
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► How to create a scheduler in BluePrism
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► How to create an environment variable in BluePrism
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► How to create credentials tags in BluePrism
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Amazing Tricks by Code Gun:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Subscribe and hit the bell to watch new videos:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Find Code Gun on social media:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► This video will solve...your Queries related to the following:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
blue prism,oledb,blueprism connect to oracle db using oledb,CODE GUN,blue prism code gun,codegun,oledb in blue prism,oledb blue prism,oledb connection in blueprism,read excel files with oledb in blue prism,read bulk data in blue prism,read excel sheet in blue prism,write to excel in blue prism,Blue Prism Code Stage,Blue Prism Oledb,sql queries in oledb blue prism,Excel VBO in blue prism,read data from excel in blue prism
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Note: This video is just for education purposes.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank You !!!!
Code Gun

[aimannishat]

what do we need to give database connection details?

[psaran]

Hi sir can you please give me a query where I need to get 3 or 4 columns from the excel (columns not in continue order)

[Yog]

Hello Sir,
I have 1 Doubt, When my Bot At Production run succefully but client want run 50, 60, 70 random numbers of records from total records. without human intenvention how its possible, , ..and we designed separate bot for queue data loader and processor

[aayushupadhyay]

Please give the link for the excel file you have used

[ABhi_rajya]

not understanding how this read by breaking data will help... we need to carry out expressions\calculations on the entire set of data like but in this case we are not getting it at once in collection .. if we combine collection also it wont help as system or BP will have data issue..

[psaran]

Can u help me out ..I don't want duplicates rows from excel how can I do from oledb ..From the same excel i need to select 4 columns only

[ajityadav]

Please dont speak in that accent.. Speak normally, it will be more understandable..