Use the Excel Query Add-in to Link a Query to a Spreadsheet [Video]

 

Review the procedure below to link a query to an Excel spreadsheet.

Steps

1. Create and save a query. Verify that it works correctly.
2. Save the query as a .dbq file.
3. Within Excel click ShowCase > Queries > Add.
4. Find the desired query and add it.
   If the Query is closed, an ODBC login dialog box may appear as well as any prompts in the query.
5. Click OK.
6. To add column headings, highlight the number of cells to contain columns.
7. Click ShowCase > Query References.
8. Click Add.
9. From the Category drop-down menu, select Column Headings and the columns to appear in the sheet.
10. Click OK to display the column headings.
11. On the worksheet, highlight the number of columns that will be brought into the worksheet, 2 rows deep.
12. Click ShowCase > Query References.
13. Click Add.
14. From the Category drop-down menu select Detail Data.
15. Select the column(s) to bring into the worksheet.
    Important: The number of columns highlighted must match the number columns originally highlighted on the worksheet.
16. Click OK to display the data.

For more information about linking queries to Lotus or Excel sheets, refer to other resolutions within this search or STRATEGY's online help (search words: ADD-INS or QUERY REFERENCE)

Video

IBM Ref#: 1475609