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


  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)


IBM Ref#: 1475609

Still have questions? We can help. Submit a case to technical support

Last Modified On:
You don't have the appropriate permissions.
No, open a new Support Case