-
Insert Statement
Hello all,
How do I use an SQL statement to insert into a recordset?
Currently I have this:
Code:
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
-
Re: Insert Statement
You don't use a recordset object for an INSERT.
You use the Execute method of your connection object.