link odbc from multiple sources

  • Thread starter Thread starter Royce
  • Start date Start date
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.
 
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
ODBC Data errors in Access 2007 1
Access 2007/sql2008 ODBC issue 1
ODBC to OLEDB - VFoxPro 5
ODBC Link Tables to Two Databases... 1
Access link ODBC to SQL table,path to ODBC -recent install? 1

Back
Top