How do I query an Excel worksheet as a PC file using Showcase Query?
In Excel97 or later, save the file as usual. In pre-Excel97, files must be saved as Microsoft Excel 4.0 worksheets. (Either through Excel or as a target file type in Query)
Open Microsoft ODBC Administrator: Use either 16-bit or 32-bit, depending on which version of Query and Report Writer was installed.
Example:
AFTER YOU BROWSE: C:\Excel AFTER YOU COPY: C:\Excel\workbookname workbookname workbookname
The copying of the workbook name to the path is very important. Browsing will not automatically pull it in. In pre-Excel97, you will find that when browsing to select a workbook, Query will enter the path in the Workbook window and add the workbook name to the Table window. This is not correct. Be sure that the workbook name is included to the path in the Workbook window, and then click on the table drop down to see tables for that workbook. These tables will be the names that were created in the first part of resolution.
Using this method multiple tables from one worksheet or even multiple tables from multiple workbooks can be chosen.
Remember: If another file is used, that workbook name must be added to the path.
Ref#: 1475533
Still have questions? We can help. Submit a case to Technical Support.