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.