Microsoft Excel is a commonly used application that can extract external data using its Import wizard. This section explains how to extract data from SQL Views using Excel. Sample reports are available in /OperationsCenter_install_path/database/examples/mosql.
Figure 3-1 Data from SQL Views formatted in Microsoft Excel
To extract data from SQL Views into Excel:
Launch Microsoft Excel.
Click
> , then select to open the Choose Data Source dialog box:Select
, then click to open the Query Wizard – Choose Columns dialog box:Select the tables and columns for your query, then click
.The remaining wizard pages are standard Excel dialogs. For information on these features, see your Microsoft Excel documentation.