Need to pull data from different MSDE servers

[hansduncan]

How can I pull sales data from several different MSDE (SQL) databases (that all have the same table structure) and load it reliably into a consolidated database or reporting cube? I want to use the Pivot Reports and the OWC Pivot on my sales data.

It is no problem creating this for each server seperately, but the challenge is to consolidate the data......

I guess I could buy an expensive SQL server and use the analysis service tool, but is there any way of doing this with the standard office toolkit?

Any help would be appreciated.

 

[XL-Dennis]

Hi Hans,

What about creating a JET Database (aka Access DB) and collect the data to it via ADO / SQL?

Then You can use the DB as the single source for the OWC components.