INSERT INTO Statement (Microsoft Access SQL) [Access 2007 Developer Reference]

Adds a record or multiple records to a table. This is referred to as an append query. Syntax Multiple-record append query: INSERT INTO target [(field1[, field2[, …]])] [IN externaldatabase] SELECT [source.]field1[, field2[, …] FROM tableexpression

msdn.microsoft.com