link odbc from multiple sources

R

Royce

I have two sources of data. Server 1 and 2 that have the same type of data
but for different stores. Right now I have to pull the data seperately and
then copy and paste in excel to merge into 1 file. Makes the process slow.
Is there a way to link both sources and essentially have them one on top of
another. Another words pull them at the same time into 1 single linked table.
 
G

Gina Whipp

Royce,

I would pull the data in and then append it to a single table and export to
an Excel file because tables can only be linked to one data source.

I'm curious, why not just drop them to an Excel workbook and merge there,
since you say the copying and pasting is slow?
 

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

multi-source odbc to single table 8
ODBC Link no System Data Source Tab 2
Can't Get to ODBC data sources in Access 2003 1
Access 2007/sql2008 ODBC issue 1
ODBC Data errors in Access 2007 1
Access link ODBC to SQL table,path to ODBC -recent install? 1
Using an ODBC link table in MS Access query as data source for a Word mail merge 0
How to call open a Word doc with links from within Access 2003 1

Top