Microsoft Office® Access 2007 Inside Out

Inserting Data from Another Table

Using an append query, you can copy a selected set of information from one or more tables and insert it into another table. You can also use an append query to bring data from another source into your database—for example, a list of names and addresses purchased from a mailing list company—and then edit the data and insert it into an existing table. (You learned how to import data from external sources in Chapter 6.)

An append query, like a make-table query, provides a way to collect calculated totals or unnormalized rows from several tables. The difference is that a make-table query always creates a new table from the data you select, but an append query copies the data into an existing table that might or might ...