Create a query from an existing data source

To create another audit report from the data source you created in Set up a connection to the database:

  1. In Excel, go to the Data tab, click From Other Sources, and then click From Microsoft Query.
  2. In the Choose Data Source dialog box, clear the Use the Query Wizard to create/edit queries check box. Select the data source you created previously (for example, SophosAuditing) and click OK.
  3. In Microsoft Query, click the SQL button and enter a SQL statement for your report.

The following section contains some examples you can use.