Updating to Access Tables

[THOMASNG]

I am using VB6 with ACCESS 2000.
With only ACCESS 2000, I am defining a complete listing
(table) of all the containers currently in a seaport.
However, using VB6, I am updating a PARTIAL list of the
containers, and storing this under a slightly different filename.

I would like to perform a merge ("mail-merge"?) of these two lists, letting the first listing exist (if the second listing has no update for the corresponding container), else preferring the second listing.

 

[coco86]

if I'm understanding your goal correctly, I think you may want a union query.

Something like:

Select * from table1 where [DefiningCriteria] not in (select [DefiningCriteria] from table2)

union all

Select * from table2;