Using Excel As Database in UiPath

We will use this method in UiPath to access the Excel as a Database and for that we need OLEDB Engine. You can download it from here:

So what is OLE DB ?

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner.

Follow these steps to setup connection and used the excel as a database:

• First of all, use the Activity Connect to Configure Connection and create its variable "conn"

FileName: Full Path of Excel File 

Connection String: Provider=Microsoft.ACE.OLEDB.12.0; Data Source=FileName; Extended Properties='Excel 12.0 XML;HDR=YES;ReadOnly=False' 

Provider Name: System.Data.OleDb

HDR=Yes -- Indicates that the first row contains column names. 

• Then use the Activity Execute Query and pass the connection String variable in its existing Connection and write query like this.

• Then you can write the data you want into excel or play with the data any way you want as it gives you output in DataTable.