Do you mean table A and B vs field A and B?

On the addition part are there records that are in table A that are not in table B that you want to move over?

Select * from Table A WHERE FieldA NOT IN (Select Field B From TableB)
do while not rst.eof
'Insert record code here....
rst.movenext
loop

You can do the deletion pretty easy with a query...

Delete from TableB Where Fieldb NOT IN (Select FieldA From TableA)

Not exactly sure if that is what you are looking for, because I am not quite understanding the problem.