Retrieving Data

There are two methods for retrieving data with Microsoft® Visual Basic using PivotTable® Service: you can use the Microsoft ActiveX® Data Objects (Multidimensional) (ADO MD) Cellset object or the ADO DB Command and Recordset objects. The ADO MD Cellset and Axes objects are used to retrieve the results of a Multidimensional Expressions (MDX) query. Using the ADO DB Command and Recordset objects with an SQL or MDX statement retrieves the data into a flattened rowset.

You can also use OLE DB to retrieve data from a cube or data mining model. The primary interfaces for this are IMDDataSet and IRowset interfaces. For more information, see the OLE DB documentation.

See Also

Using the Cellset Object

Using the Recordset Object