How to Insert data into a table

[sarah2855]

I have opened a recordset and now I want to copy all the records of that recordset to a table.

set rs = db.OpenRecordset("SELECT ID FROM Customers")

This command gives me the list of all Ids in Customer Table.
How can I now Insert this list in to a table?

[sarah2855]

I got it myself I needed to do:

strSQL = "INSERT INTO temp( ID )" & _
         "SELECT ID FROM Customers"