Excel Connection?

[Former Member]

I'm using SAP Crystal Reports for Enterprise, and in the help section it says that excel is a valid data source.

However there's no help on how to actually connect to an excel spreadsheet, anywhere that I can see.

Have people had success in building sub-reports/reports with an excel spreadsheet as the data source?

[Former Member]

Hi Matt,

Please refer to below link:

http://scn.sap.com/docs/DOC-29864

Thanks and Regards,

Deepa.

[abhilash_kumar]

Hi Deepa,

That is a CR 2011 related document.

The product in question is CR for Enterprise.

-Abhilash

[abhilash_kumar]

Hi Matt,

1) Setup a 32-bit ODBC Connection to the Excel File using the 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)' driver.

2) Open CR for Ent > Choose Data Source > Connection By Vendors > Microsoft > Microsoft Excel 2007 > ODBC > Choose the ODBC you created in Step 1.

-Abhilash