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

... the Microsoft Access database engine appends records to any and all tables specified by the query. ...

msdn.microsoft.com