You can use a query to add records to a table by creating an append query . If the fields you've selected have the same name in both tables, Access automatically fills the matching name in the Append To row in the design grid. If the fields in the two tables don't have the same name , enter the names of the fields in the Append To row in the design grid. If the table you are appending records to includes a primary key field, the records you are appending must have the same field or an equivalent field of the same data type. Access won't append any of the records if either duplicate or empty values would appear in the primary key field.
Add Records with a Query