can i use excel 2000 to connect to as 2005 data source?
cherriesh
You should be able to, as long as the latest OLE DB for OLAP Provider is installed on the client and supports AS 2005 (ie. MSOLAP.3).
Feature Pack for Microsoft SQL Server 2005 - February 2007
...
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
The Analysis Services 9.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining....
|||How to connect Excel 2003 or an earlier version of Excel to SQL Server 2005 Analysis Services
http://support.microsoft.com/kb/940167
No comments:
Post a Comment