VBA Code to Consolidate Two Tables and Remove Duplicate Entries

[joeyT]

Hello,

As shown in the following, I have two tables in my Access database. Table 1 has three columns, First Name, Last Name and Phone Number. Table 2 has just 2 columns, First Name and Last Name.

What I would like to do is write a VBA macro to consolidate Table 2 into Table 1 and insure any duplicate First Name-Last Name combination is removed. Any help will be much appreciated

Table1

F.Name  L.Name   Tel.N.
John       Smith    12345
Larry      Miller     12344
Tony      Woods   12333

Table2

F.Name  L.Name
Albert     Black 
Larry      Miller
John       Bush

Table1 Post-Macro

F.Name  L.Name   Tel.N.
John       Smith    12345
Larry      Miller     12344
Tony      Woods   12333
Albert     Black
John       Bush
 
[COLOR=red]'Note that Larry Miller was not added from table2 because it is a duplicate[/COLOR]

 

[plog]

What you want is a 'Full Outer Join'. Google that term, or check out this link:
http://dba.stackexchange.com/questions/14441/full-outer-join-in-ms-access

Access doesn't natively support them, but you can hack them together. No VBA or macro necessary.