I want to connect Microsoft Excel as a Database and perform DML operation over it.Please help

[ravi.g6]

Hi all,

I am working on an Automation where I have to connect Excel as a Database can anyone help me with the steps to how to connect it on UIPATH Studio.

Thanks,
Ravi

[Ajju (Ajjayya Hiremath)]

hi @ravi.g6

below threads may help you

How to connect Excel with Database

Hi @Santhosh_Hyd, The .xaml Excel DB Connection.xaml (11.9 KB) can be added to your UiPath library and then it will make easy for you to connect excel to database whenever needed as I created something generic which relies in dynamic variable (excel file name, excel sheet name). It also gives you two SQL statement (select, update) to facilitate interacting with the file. Additionally, you can refer to this link to better understand the syntax needed for querying and updating excel files with …

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.

How to use Excel as datasource and execute SQL Query?

Hi Team, I am trying to connect Excel as datasource, but not able to connect. I did some research and found following post. But still it is not helpful getting same error as mentioned. I have attached the excel file. I am looking for correct connection string for xlsx or xls and SQL query. Source.xlsx (8.6 KB) Kindly assist.

Regards
Ajay