Insert Into versus Select Into

[ThisIsntMyRealName]

Hey guys, I was using "SELECT INTO" in access 2007 to insert all values from one table into another. This function deletes the table then reinserts everything. If i wanted to use INSERT INTO and insert all values from 1 row of one table into another how would I write this?

 

[Joe4]

INSERT INTO [Destination Table Name] (Field1, Field2,... )
SELECT [Source Table Name].Field1, [Source Table Name].Field2, ...
FROM [Source Table Name]

Of course, you may have criteria also (WHERE...).

In Access, adding new records from a query to an exisiting table is known as an Append Query. You can create this in Access using the Query Builder. The nice thing about that is you do not have to known SQL to do this. Or, if you want to know what the SQL would look like, create the query using the Query Builder, then switch the Query to SQL View. This is a great tool for verifying Query structure.