Share this Page URL

Chapter 15. Integration with Office 2003... > Analyzing Access Data Through Excel - Pg. 557

Integration with Office 2003 and SharePoint Services 557 6. 7. In this example, we won't filter on any of the columns. However, if you want to filter the data so that only certain values appear in your spreadsheet, you can do so in this screen. Click Next. In the next screen of the wizard, you can set the sort order for the columns. As with most Microsoft Office applications, you can choose up to three fields on which to sort. In the first drop-down list, select the OrderID field, and make sure the Ascending option is selected, as shown here. We won't sort on any other fields now, so click Next. 8. Excel provides several different choices on the final screen once you've constructed your query. You can view the output in Microsoft Query or choose to create an OLAP cube. OLAP stands for online analytical processing and is essentially a pivot-table query. OLAP queries are not covered in this book, but there are a lot of excellent online resources (see the related topics on the MSDN website) that discuss OLAP queries. In addition to choosing the finish event, in this screen, you can save your query to a file for easy access later. Select the Return Data To Microsoft Office Excel option, as shown here, and click Finish.