Copying using recordsets to new records

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I'm trying to read a field in some records in one table, perform some
querying on the field, and write the result out to new records in another
table. This cannot be avoided. I figured I could do this using recordsets.
But I'm stuck on the coding for writing the new records out. I have:

Set rs = db.OpenRecordset(SQLstr)
rs.MoveFirst
Do Until rs.EOF
'read some tables
'how to write a new record to another table?
rs.MoveNext
Loop

In the above, SQLstr is used to pull in some existing records. How do I
code to write new records? (in an existing table)

Robert
 
Back
Top