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