How to use Excel as a Database in UiPath

Nitya1 · June 6, 2022, 9:37am

Are you curious about connecting Excel as a database in UiPath.

Let’s see how to do that.
Step 1-

Drag the connect activity in the main sequence workflow.

Step 2:-

Click on ‘Configure Connection’ button and we would see the below window as shown.

Step 3:-

Click on ‘Connection Wizard’ button and Choose the Data Source as < other> & Data Provider as .NET Framework Data Provider for ODBC & click ok button.

Once you click on OK button, then set the properties on the Connection string window.

Step 4:-

Under Data Source Specification, Choose the ‘Use Connection String’ icon & Click on Build button.

Step 5:-

Select the tab ‘Machine Data Source’ as shown in the below window.

Step 6:-

Now, click on New button.

Step 7:-

Once you click on New button, then we would see the below image, ignore the image by clicking on Ok button.

Step 8:-

Once you click on ok button, then on below window click Next button.

Step 9:-

Now, select a driver for which you want to set up a data source.

As we are currently dealing with Excel, so we will look excel drivers and Click Next.

Step 10:-

Finally ,we click on Finish button.

Step 11:-

Now, we will do ODBC Microsoft Excel setup and for that we have to provide Data Source Name of your choice , description is optional and select the workbook from the specify location where the file is placed and click on ok button.

Step 12:-

Now click on ‘Test Connection’ button to test the connection. If the test connection succeeded , then click on ok button.

Step 13:-

We will save the connection in the output variable as ‘ConnectionString’

Step 14:-

Above all the steps are used to connect Excel as database , now we will execute the query from excel , for which we will use ‘Execute Query’ activity.