Use excel as Database

[Palaniyappan (Palaniyappan P)]

Hi

Here you go with the reference from UiPath knowledge base to get his resolved

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…

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…

Video demo

Use mysql to retrieve data from the Excel into a data table

Hi, In order to connect dynamically to Excel from UiPath I suggest you use OLEDB. Then you will be able to use mysql to retrieve data from the Excel into a data table. Here is a YouTube video how you can do it: [UiPath: Manipulate Excel with SQL]

Hope this helps

Cheers @garimavarshney9