Insert Statement

[otacustes]

Hello all,

How do I use an SQL statement to insert into a recordset?

Currently I have this:

        sql = "INSERT INTO AB (catalog, user1) SELECT (BA.catalog, BA.user1) from BA;"
        
        Set rs = db.OpenRecordset(sql)

what I need to know is how do I replace the AB part in the insert statement to indicate that I want to add the data to the rs recordset?
Hopefully this makes sense?

Thanks