[AccessD] Quick Update Solution

Is there a quicker/better way to append data than the method I currently 
use:

select all records from table 1

move to first record in table 1

loop through every record in table 2 to see if a match occurs on LINK_PT 
field

If there is a match it is skipped.

If there is no match then table 1 record is appended to table 2

Move to next record in table 1 and continue loop until .eof

I can do it this way but is there another quicker solution. As the tables 
grow the speed slows. I am using A97 for the app.

Thanks

Paul

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail