Training

When creating prompts in ShowCase Query, you can use Excel as the source for prompt answers. The Excel sheet creates a list of choices in the prompt, or you can use it to answer the condition without having to answer the prompt. When choosing an Excel sheet, make sure that you pick a version of Excel that contains only one sheet, such as Excel 4.0 or later versions (excluding Excel 8.0). And don’t use an Excel sheet with column headings, or they will appear either in the list box or as values in response to a prompt.

Take the following steps to use Excel as a source for prompt answers:

1. Create or modify the Excel sheet to contain the list and save it as an Excel 4.0 worksheet.
2. Create your query.
3. Create your condition using prompts and complete the Prompt Attribute box.
   • Choose List of Values from a PC file as the source of prompt answers:
     

     
     Click to enlarge.

   • Then select Source Details (see above) and click Browse to choose your spreadsheet:
     

   
   Click to enlarge.

   • Select Use values without prompting if you would like the list in the spreadsheet to be used without asking you to make selections from the list. Use this option with caution as it will use the complete list and even consider the column heading as a value.
   • Select OK to close the dialog boxes.
4. Complete your query as needed.