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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top