I have to build 1 table from variables in another. There's allot of logic being applied from the first table so it's not a simple insert. The problem is doing this
rsSource.open mytable, ...
while not rsSource.eof
lots of logic
rsDest.field1 = rsSource.field1
just takes too long with 20,000 records. What would be some faster ways to do this?