Copy related multiple records into another database.

has_access

New member
Local time
Today, 21:48
Joined
Aug 15, 2018
Messages
9
How do we can append multiple related records from two related tables into similar tables in another access database?

I have a database in Access 2016, It contains 2 related tables by a (one -many) relationship.
How I can copy multiple records from this database (each record have a related data in both tables) into another database?
Is there are a simple automatic query or script to do that without my interference?
Thanks
 
Open your destination database. Link the two tables from your source database.
Create an append query to copy from source table 1 to destination table 1
Repeat for the other tables
 

Users who are viewing this thread

Back
Top Bottom