Connect HomeMarketplaceComponentsXebia - Select Query Using OLED

Xebia - Select Query Using OLED

Workflow Template

Workflow Template

Updated: August 29th, 2020

Published: May 9th, 2019

Downloads: 27

Language compatibility: Visual Basic

Community Support

Xebia - Select Query Using OLED

Workflow Template

Summary: 

When we are working on huge data sources .xlsx format, then select Queries becomes inefficient on data tables


Details

Benefits

The user needs to provide the following information on Config Files and they can directly establish connection with Excel sheet with the help of OLEDB.
i. File Path
ii. SheetName
iii. Header Required or not
iv. SQL

Compatibility

2019.4.2 Community Version

Dependencies

i. OLEDB Driver should be installed in the system.
ii. UiPath Database package should be installed in the Studio.

Resources

- Re-Usable_Workflow___Select_Query_Using_OLEDB_Connection.docx

Licensing

By clicking download you agree to the following license.