Excel Forum

Using Connection Only Queries to another file

Faltoo Reg

New Member

Members

Forum Posts: 2

Member Since:
September 21, 2021

Offline

September 21, 2021 - 8:01 pm

Hi,

Suppose I have 2 excel files "A" and "B". Assuming, file "A" has three connection only queries i.e A-COQ-01, A-COQ-02 and A-COQ-03. On the other hand, file "B" has just one query that is prepared as "Load to Table" its name is B-Query-01, but I want to merge connection only queries made in file "A" with query B-Query-01 that is made in file "B".

Thanks,

Mynda Treacy

Admin

Forum Posts: 4524

Member Since:
July 16, 2010

Offline

September 22, 2021 - 6:55 pm

Hi Faltoo,

Welcome to our forum! You would need to use Power Query in file A to get the data in the table in file B. From there you can then merge your 4 queries in file A.

Mynda

Faltoo Reg

New Member

Members

Forum Posts: 2

Member Since:
September 21, 2021

Offline

September 22, 2021 - 7:52 pm

Hi Mynda,

Sorry seems i did not explained clrearly. In fact, my file "A" contains "Connection Only" i.e A-COQ-01, A-COQ-02 and A-COQ-03 not table. So in that case how i can user these connections in file "B" through power query.