Run a SQL query on existing recordset?

Question

I've created a 3rd recordset (disconnected) from two existing recordsets that came from different connections.

Now, I'd like to run a SQL query on this 3rd recordset.

I am using Excel VBA.

thanks, Harry

Answer 1

You can use the ADO RecordSet Filter method with SQL where clauses: Filter and RecordCount Properties Example, e.g.

rs.Filter = "SupplierID = 10"