How do I merge to a database from two odbc sources?

[MrCheese]

I have an Access database which I want to import ODBC data in to from 2
different servers. The are both set up exactly the same, the only thing that
differs is the field values. What is going to be the best way to do it?

 

[John Nurick]

Hi Mr Cheese (may I call you Gorgonzola?)

I'd probably just set up a pair of linked tables, one connected to each
server (or more than one pair, if there is more than one table in the
data source). Then use queries on the linked tables to extract or
manipulate the data.