Comparing Recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Heres the problem:

I have a table that contains a list of customers and this needs to be
updated. So I create another recordset which holds a more up to date list of
customers. I create a recordset of the table of customers and what I am
trying to do is to compare the 2 recordsets and take out the new customers
from the more up to date recordset. Ive tried this using nested do while
loops but it takes ages!!! (At the mo there are arounf 3000 records in 1
recordset and 3050 in the other!!!)

DOes anyone know a quick way of doing this as when I run it my CPU usage
goes through the roof and its takes around 3 minutes!!!!

Thanks in advance

Dave
 
Hi,
best is to use a query. make 2 queries with customers, then you can run
unmatched query wizard to get a query of new customers, and them make a
apdate query to copy new customers to then destination table
 
Brilliant. Thanks a lot

Alex Dybenko said:
Hi,
best is to use a query. make 2 queries with customers, then you can run
unmatched query wizard to get a query of new customers, and them make a
apdate query to copy new customers to then destination table
Click to expand...
 
Back
Top