Connect to MS Excel as Databse

[Saran_Raj]

Hi Friends,

Can anyone help me to write sql select query while connected the excel as database connection.

[AshwinS2 (Ashwin S)]

Hi @Saran_Raj

Why do you want to connect Excel as database

Thanks
Ashwin.S

[Palaniyappan (Forum Leader)]

Hi
Welcome to UiPath community

Hope this could help you resolve this

Connection string for excel

Hi Can any one help me connection strings for excel. what needs to be provided in the connection string for excel. I have scenario where i need to query the excel. I had huge data with multiple columns, i need to use filters for multiple columns and base on each filter i need to set a value for the filtered results. Thanks for the help in advance.

Cheers @Saran_Raj

[loginerror (Maciej Kuźmicz)]

Hi @Saran_Raj

Welcome to our UiPath Forum!

I’ve seen this post in the past with a sample on how to achieve it:

Sample to use Excel as Database

Hi All, Please find the sample project. This project has all the Insert/Update/Select database queries on Excel file as Database. You have to install the Database activities from the manage package. This will be useful to update/Read a common file in case we are running multiple BOT’s without Orchestrator on multiple machine that file can be placed in the share drive. ExcelAsDB_SampleCommands.zip (20.2 KB) Hope this will be useful for all. Regards HJ

It should be of help here