How do I use EXCEL as a data source in crystal reports 2020?

[gabriel_schroedter]

How do I use EXCEL as a data source?. I am running Windows 10, and with previous editions, Excel was part of my drop down list for connections along with ACCESS

Where did it go?

Is there a guide for this process?

[vitaly_izmaylov]

https://apps.support.sap.com/sap/support/knowledge/public/en/2970410

[DellSC]

Also, Crystal 2020 is 64-bit, so you would need to have the 64-bit version of Office in order to connect directly to Excel. With earlier versions of Crystal, you needed the 32-bit version.

-Dell

[ido_millet]

ODBC connection to Excel requires that you use Tables or Named Ranges for each target range of data.

[former_member1084593]

Tried to add ODBC Connection (not sure it is an upgrade over 2016) if I have to add ODBC for every excel file I use... When I added the ODBC and went into CR2020, I could connect, but I do not see the sheets in EXCEL.

[jameswilliams]

This link may be of use - SAP Knowledge Base Article - Public 1669329 - How to create a report of MS Excel spreadsheet saved ...