Combining identical access databases

[joan]

I have two access databases with identical schema (Many
tables, huge number of fields, few records). I'd like to
quickly combine the two into one consolidated DB. ( Many
tables, huge number of fields, few records). IS there a
quick way to accomplish this.

Thx

 

[Glen SIdelnikov]

Sure!
Combine them quickly!!!
Seriously, the "combining" word gives you too many scenario.
Give at least one and reformulate the question...

 

[Kevin @ 3NF]

Write a series of append queries and append the data in one database to its
matching table in the other. Just make sure you go in the same direction
for each table pair.