Run a database query

The Databases task pane lets you browse or search a database (run a query), select a set of records from the results, and then add the selected data to your map as database topics.

Run a query

1. On the Insert tab, click Databases, and then click Browse Connected Databases.

2. In the Databases task pane, choose a connection in the Select a database connection list.

• If you have not set up any connections, or if you want to connect to a different database, click to add a connection.

• If you want to configure the connection you've selected, click .

3. Choose a table to browse or search in the Select a database table list. You can hide tables in this list in the configuration.

4. All the records in the table now appear in the Results pane.

• To choose the columns to display in the Results, click .

• To search for records with matching text, type it in the Enter text to find field. Matching records appear in the Results pane.

• To further refine the Results, enter text in the Filter field. You can enter multiple terms in this field, separated by spaces. The Results will now be reduced to records that contain at least one of the filter terms in any of their fields. To remove the filter, click .

Add data to your map

You can choose to add all of the data in the Results pane to your map, or only selected records.

1. If you only want to add selected records, select them in the Results. (CTRL+click to select additional records).

2. Then, do one of the following:

• Drag the records from the task pane onto the map.

• Click Add to Map at the bottom of the pane, and choose which records to add, and where to add them.

If you have configured the connection to specify which fields to include in the topic text, and which fields to show as basic properties, these settings are used to display the topic data. Otherwise, the topics show the fields you have chosen as visible in the Databases pane.

You can change which fields are used for the topic text and basic properties.