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 dat...