Copy recordset between two different db

I have two different db: PervasiveSQL and Access.
How i do, in vb6, to copy a recordset from first to second db.
CLONE metod don't run, because Pervasive does not support bookmarks.
The table are the same
I open the connection for the db, and then the two recordset:
rst1.open"select ..........." for pervasive
rst2.open"select ..........." for access
rst2.addnew
and then?
Best regards, Flavio

Welcome to th eForums.

Easiest would be if you already have the duplicate table structure created in your destination database, execute a series of INSERT INTO sql statements. It will be faster then selecting data into a recordset and writting it back to the destination database one field at a time. :)