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?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
"Royce" <Royce[ at ]discussions.microsoft.com> wrote in message
news:D6A9C503-01B7-429A-AE5A-0184CC45E8C8[ at ]microsoft.com...
[Quoted Text] >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.
|