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
- There is a limit of 255 fields that can be used in a query when the datasource is Excel/Access
- This is a Microsoft Jet database engine limitation
- See the Microsoft KBase ACC2000: "Too Many Fields" Error When Tables in a Query Produce More Than 255 Columns
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