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."
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.