add fields to table from recordset

[SigAlpha]

I have two tables with the exact same structure, one table has customer info. in it and the other one is empty. What I have done is created a recordset to hold info from the customer table based on search material supplied by the client. I now want to be able to fill in all the selected records to the temp table but would like to do it without having to list every field in an Insert Into statement because there are like 50 fields.
Can I some how make a statement like "Insert Into tempTable * objrs" because I'm going to be filling in every field.

This would be so much more easier, and I'm sure its possible, but I can't figure it out.

Thanks...

[BruceG]

You can do something like the following:

Dim objField         As ADODB.Field  'or just "Field" if DAO
Dim strFieldName As String
Do Until Recordset1.EOF
    For Each objField In Recordset1.Fields
        strFieldName = objField.Name
        Recordset2.AddNew
        Recordset2.Fields(strFieldName).Value = objField.Value
    Next
    Recordset2.Update
    Recordset1.MoveNext
Loop

[SigAlpha]

Thanks Bruce but I wanted to know if there was a sql statement that I could use. I already knew how to do it with a recordset object, but I'd like to avoid creating another one if possible.