SAP Knowledge Base Article - Public

1682175 - DAO Error Code: Oxc76 when connecting SAP Crystal Reports to Excel

Symptom

  • SAP Crystal Report is connecting to Excel using DAO
  • When the Excel file has more than 8 sheets the following error is thrown:

Database Connector Error: 'DAO Error Code: Oxc76
Source: DAO.Database
Description: Too many fields defined.

Environment

  • Crystal Reports 2011
  • MS Office 2000

Cause

Resolution

Limit the query to less than 255 fields

Keywords

xls xlsx , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2011, feature pack 03