Transfer table from one database to another?

i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfe开发者_如何学运维r them but i am confused

You can use the TransferDatabase method of the DoCmd object to link relevant tables and then run suitable append and update queries to synchronize.

You can access a table in DB X without actually transferring the table into DB Y.

SELECT *
FROM TableInDbX IN 'C:\SomeFolder\DB X';