Link a table to a query from another database

[Leo_Polla_Psemata]

Hi
We can link a table data source to another table from another database.

Could we link table to a query ? (not table, link to a query)

 

[sneuberg]

I can't see how. What's your end goal? Maybe there is some other way to do it.

 

[Leo_Polla_Psemata]

I have tow database. Say A and B

A db, needs information pieces from a query in B db.
So far I copy the query from B and paste to table in A.
I wonder if I could avoid this copy paste by using a direct link.

 

[sxschech]

If I understand the question you can use the "In" operator to Select Data from another file in a query.

In SQL it would be typed in as:

SELECT * FROM ExternalQuery In 'C:\ExternalFolder\ExternalFile.accdb'

In the graphical interface, open the properties window and enter the external location in the Source Database box. Then when you click on the Show Table button, you can select queries as well as tables

 

[sneuberg]

If I understand the question you can use the "In" operator to Select Data from another file in a query.

In SQL it would be typed in as:

SELECT * FROM ExternalQuery In 'C:\ExternalFolder\ExternalFile.accdb'

In the graphical interface, open the properties window and enter the external location in the Source Database box. Then when you click on the Show Table button, you can select queries as well as tables

Wow! Way cool. Thanks for the post. I learned something useful today.