The query that adds a records to the end of existing table is append query.
Append query that adds a record or group of records from one or more tables to the end of another existing table.
Append query that adds a record or group of records from one or more tables to the end of another existing table.
- For example, suppose if users acquire a database that contains a table of potential new customers, and that they already have a table in their existing database that stores that kind of data. The users would like to store the data in one place, so they decide to copy it from the new database into the existing table. To avoid entering the new data manually, the users can use an append query to copy the records.
