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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

split data base using ODBC connection 1
Import tables from an ODBC database 3
ODBC Database Import / Link 3
Linking vs Importing using ODBC connected database 1
How to connect to oracle odbc data source 1
Cannot Link to ODBC Database 5
ODBC Data errors in Access 2007 1
Getting external data from ODBC error 3423 0

Back
Top