How do I copy a recordset to a new access db table? The new db is already created. Basically I have queryed a recordset from an access db, I want to run another sql on the existing recordset, and the only way I know how to do that would be to store the RS in a temp table in a new db, then run another SQL on that temp table. I am using the data designer in vb6. I cannot modify the original db, read only. In access, you can query a query, I cannot figure out how to do this in vb6, so I want to save the first "query to a temp table", then I can query that table.
How do you guys suggest to handle this?
Thanks,
Tom