Combining identical access databases

  • Thread starter Thread starter joan
  • Start date Start date
J

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
 
Sure!
Combine them quickly!!! :-)
Seriously, the "combining" word gives you too many scenario.
Give at least one and reformulate the question...
 
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.
 
Back
Top