SAP Knowledge Base Article - Public

1696691 - Excel spreadsheets not visible under ODBC connection in Crystal Reports

Symptom

  • Sheets not available.
  • No MS Excel sheets displays in Crystal Reports.
  • Connection to MS Excel only show "Add Command" option in Crystal Reports.
  • MS Excel Spreadsheets are not available when creating a report using an ODBC connection to a MS Excel document.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Microsoft ODBC Administrator, create an ODBC connection using the MS Excel ODBC driver to the MS Excel spreadsheet to report from. 
  2. In Crystal Reports, create a new report using the ODBC connection created in steps 1.
  3. It does not display anything under the new connection other that "Add Command". The MS Excel spreadsheets are missing.

Cause

  • When Using ODBC connection to MS Excel document, the spreadsheets are interpreted as "System Tables", and by default, the system tables are not visible when creating an ODBC connection in Crystal Reports.

Resolution

  • To be able to display the MS Excel sheets when using an ODBC connection to a MS Excel document in Crystal Reports, check the Crystal Reports Database Option: "System Tables"
       
    1. Open Crystal Reports.
        
    2. Under the menu "File", select "Options..."
        
    3. In the "Options" window, under the tab "Database", check the Data Explorer option "System Tables".
       
    4. Click "OK" to accept the change.
         
    5. Now, when creating a new report off an ODBC connection to a MS Excel spreadsheet, it it will display the available sheets.

Keywords

ODBC, Excel Spreadsheets, missing, Excel 2003 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016