How to use Excel as database in uipath

[Uthraa_S (Uthraa)]

Hi,

Below thread might help you.

Using Excel As Database

How to connect with Excel as a database ? Perform the details mentioned in the Step by step guide, for connecting Excel as a database Open Excel file (Note - Excel file must remain open) In UiPath Studio Drag and drop Connect / Execute (Non) query activity Click Configure connection Open Connection Wizard Select Microsoft ODBC Data Source Use Connection String Click Build Go to Machine Data Source Click New Click Next Microsoft Excel Driver(.xls) Next Finish Give Some Data Source Name and Desc…

How To Use xlslx File As A Database In UiPath And Perform SQL Queries?

How to use xlslx file as a Database in UiPath and perform SQL queries? Issue Description: It is required to use an Excel file as a Database in UiPath Studio in order to run queries for our data records. Assuming there is an *.xlsx file with these records as presented below. [image] How to use the above Excel file as a Database in UiPath? Resolution: Create a new process with Modern Design Experience enabled. [image] In Manage Packages add the UiPath.Database.Activities[1.6.1] depend…