Method 2 - through MS Query

1. Start Microsoft Word and open a .doc file.

2. If it is not already displayed, display the Database toolbar by selecting View>Toolbars>Database. Click the Insert Database icon () on the Database toolbar. The Database dialog box will appear.

3. Click on Get Data… The Select Data Source form will appear.

4. Select MS Query… from the Tools menu. Microsoft Query will start up, and the Choose Data Source dialog box will appear.

   

   (The list of data provider applications may differ from that shown above.)

5. Select the Use the Query Wizard to create/edit queries check box.

6. Click on the ODBC resource in the list corresponding to the database where the PDMS views were created (refer to Method 2 - through MS Query for a description of how to do this) and OK the dialog box. The Query Wizard - Choose Columns dialog box appears:

   

7. The Available tables and columns: list will show the available PDMS data tables (defined using the SQL Direct Table Designer). Select the required table, then click . The column headings for the selected table will appear in the Columns in your query: box.

8. Click Next>. Keep clicking Next> as the wizard dialog progresses (unless you wish to perform other operations at each stage) until the Query Wizard - Finish dialog box appears. Click Finish.

9. Returning to the Database dialog box, click Insert Data… The Insert Data dialog box then appears, which gives you some options for the formatting and content of the imported data. OK the form.

The requested data will now appear in the current Word document as a table.