Connect Excel 2007 to SQL Reporting Services models ?

Hello,

I have read that Excel 2007 can now connect to SQL Server Analysis
Cubes, as well as SQL Reporting Services Models.

I have found in Excel's Data Ribbon how to connect to a SQL Analysis
Services cube, no problem here, but I can't seem to find the SRS
Models there. I have created a model in SRS, but I have no idea where
to call it from in Excel 2007.

Thanks a lot for your help.
A

Hi,

Neither do I. In fact I've never used SRS, however, you might try this:
press Alt D, P and pick External Data Source, then Get Data.
--
Cheers,
Shane Devenshire


"tony" wrote:

> Hello,
>
> I have read that Excel 2007 can now connect to SQL Server Analysis
> Cubes, as well as SQL Reporting Services Models.
>
> I have found in Excel's Data Ribbon how to connect to a SQL Analysis
> Services cube, no problem here, but I can't seem to find the SRS
> Models there. I have created a model in SRS, but I have no idea where
> to call it from in Excel 2007.
>
> Thanks a lot for your help.
> A
>
>