Copy recordset between two different db

[flavio62]

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

[RobDog888]

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.