I have two Excel tables that need to be merged in Access table because
of Excel's limitation on numbers of rows.  Each table is setup exactly
alike w/ unique identifiers so there would be no formatting or
duplication issues.  How do I that?

I then have a third excel table that has information (as identified by
the unique identifier) on it that I need removed from the newly merged
Access table.  How do I do that?

Hi,

You have two excel for two different table.. right.

now open a new database in MSAccess, and click on file-get external data-import.

Select your first excel file. press OK

Now, select the sheet you want to import in MSAccess.

Click next and select import in new table.

Click Finish to import all data from excel to MSAccess table.

Now proceed for second excel sheet table in same way but while
importing select same MSAccess table name to import data of second
excel sheet. so that way you can import two excel table in same table
of MS Acces.

Hope you this will suffice for your problem.

DineshGohel