hi,

I am trying to establish multiple connections for multiple Excel files with different names. I can establish individual connection for each file using different methods successfully. But I need all the connections for a single query. can't make it work out.

How multiple excel connections strings can be used for single query?

What I already tried:
Embed the connection string in web.config file and call the connection variable under the query pane custom connection section. single file connection established successfully. but when I put multiple connections and it only read the last connection variable.

I also try to use Action variable for connection strings but no success.

any expert help.

Thanks