I have a VBA that queries a database and gets a set of data into a recordset. I need a way to copy this data into the table. The recordset and the table both have a same structure (1 column) and the recordset is usually large (100,000 rows) and the table is cleared before it is filed with the data.
Any way I can do an insert that copies whole recordset into table?
I've seen lots of examples where we go through each recordset and do an insert, but due to the size, i can't imagine this method being efficient.