1 query, 3 databases

[odun]

Hello all:

I have 3 tables in 3 different databases with common fields. The tables are pretty big and that is why they are in different databases.

I would like to create a make table query in a 4th database such that the query will pull the 3 tables from the other 3 databases into 1 table in the 4th database. Is this possible in access, please show me how.

Thanks much,
Odun