I have data in two access files and want to merge it in a new single file.
Pl provide full instructions.
Create a new database.
Now in the Tables view, click on File > Get External Data > Import
Select the first database file and import it.
Do the same procedure for the second file.
You will need to recreate the relationship between the tables though.