3.1 Using Excel for Queries and Reports

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:

  1. Launch Microsoft Excel.

  2. Click Data > Import External Data, then select New Database Query to open the Choose Data Source dialog box:

  3. Select MOSQL, then click OK to open the Query Wizard – Choose Columns dialog box:

  4. Select the tables and columns for your query, then click Next.

    The remaining wizard pages are standard Excel dialogs. For information on these features, see your Microsoft Excel documentation.