Question: how to transfer data from one table to another in access?
Answer: Step 1: Create a query to select the records to copy. Open the database that contains the records that you want to copy. ... 
Step 2: Convert the select query to an append query. ... 
Step 3: Choose the destination fields. ... 
Step 4: Preview and run the append query.