SAP Knowledge Base Article - Preview

2970419 - Error: 'Access/Excel(DAO) connection is no longer supported...' when refreshing a report in Crystal Reports

Symptom

  • Error: 'Access/Excel(DAO) connection is no longer supported...'
  • Report based on Excel, Access, or a Text file fail to refresh in Crystal Reports.
  • Could successfully refresh the report in previous version of Crystal Reports. 
  • Crystal Reports closes unexpectedly when trying to connect to the MS Excel.
  • When refreshing a report connecting to MS Excel, or MS Access, or a Text file in Crystal Reports, it fails with the error:
          
       "Failed to load database information.
       "Details: Access/Excel(DAO) connection no longer supported,
         use another alternative if possible, e.g. ODBC/JDBC."

    Followed by:

       "Failed to load database information."
          
      
    DAO Unsupported.png


Read more...

Environment

  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025
        
  • MS Excel 2013
  • MS Excel 2016
  • MS Excel 2019
        
  • MS Access 2013
  • MS Access 2016
  • MS Access 2019

Product

SAP Crystal Reports 2020 ; SAP Crystal Reports 2025

Keywords

CR, deprecated JET, CR2020 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.