Hello,

This may sound familiar to some, but I have tried several approaches to this
problem.  The VB approach is beyond my VB skillset given the timeframe I have
to get this done, so here goes an attempt using and append query...

I have tblCandidates and tblRRDExport.
1) Find the next record in tblRRDExport to be appended to tblCandidates.  
This is signified by tblRRDExport.ImportDate being null.
2) Find the next "X" amount of record to be imported.  "X" is inputed by the
user (if this is not possible use 250).
3) As the records are appended, make sure they do not already exist in
tblCandidates.Number.  If the export number exists in Candidates, then mark
it as imported and get next record - careful to make sure a total of "X"
unique records are actually selected.  All successfully imported records
should have tblRRDExport.ImportDate set to current date.
4) When "X" number of records are appended then end.

Start tblRRDExport:
Name         PhoneNumber    ImportDate
Doe John     5556667777      
Doe Jack      1116667777      08042006
Doe Joe       3336667777      
Doe Jane     2226667777      

Start tblCandidates:
Candidate      Number
Smith Mary    4445556666
Doe Jack       1116667777      
Naft Connie    1112223333

Resultant tblRRDExport:
Name         PhoneNumber    ImportDate
Doe John     5556667777      08072006
Doe Jack      1116667777      08042006
Doe Joe       3336667777      08072006
Doe Jane     2226667777      08072006

Resultant tblCandidates:
Candidate      Number
Smith Mary    4445556666
Doe Jack       1116667777      
Naft Connie    1112223333
Doe John     5556667777      
Doe Joe       3336667777      
Doe Jane     2226667777      

Thanks much!