I have two ADODB recordsets set up connected to two different databases one is Access 97 the other SQl Server 6.5.
How can I transfer data from one recordset to the other, mainly SQL 6.5 to Access 97 using VB6 Code.