Copy data from another database

[tpk]

Is that possible to import some data (not all) from a query in another database ? I do not want to import the whole table because the table is too big. I hope do not need to create the query in the original database as it is our master database.
Can anybody advise me ?

 

[Mile-O]

Use an APPEND Query - they are explained in the Help files.