I want to use execute query to run query on two excel files query having join operation as well please suggest

Help Forum
1

I want to use execute query to run query on two excel files query having join operation as well please suggest. Query is complex thats why I am looking to run through execute query.

2

Also , help me to create connection string for two excel files.

3

Hi @Saurabh_Singh4
can u explain what u need to be done with excel files with screenshots ?

4

I have two excel files that I want to use as data source like database so what will be the connection string for connect activity.

5

And second question is how I can write query in execute query activity on two excel with join operation. If you provide me some example at your own end that would be great. My data is official so I can’t share like that. Thanks in advance

6

Hi @Saurabh_Singh4 ,

Please use following code
Flat DB.zip (11.9 KB)

in here i used ODBC drive as excel source
image

image

image

Happy Automation