The fastest way of copying fields between recodset
Linked tables in Access are probably the way to go here.
Because then you can have Jet do an UPDATE statement to update
all of the rows without having to loop through recordsets.
But if using pure ADO declare and bind individual field objects
for each field in each recordset.
dim faName as field
dim foName as field
set faName = rstAccess.fields("Name")
set foName = rstOracle.fields("Name")
do until ...
faName.value = foName.value
I have two connections (Oracle and Access) and two recordsets and I'd like
copy some fields between recorsets (about 100.000 records). Can you tell me
method of copying? Can I in some way bind my recordsets in one enviroment
using linked table in Access or DataEnviroment in VB? Maybe instead of
I can use ADO streams? Help :-)
VB6, SP5, ADO 2.6, Win2k