Adding an Excel worksheet to a Crystal report

[bcmom90]

We are using Crystal version 9 connecting to an Oracle 9 database. I have created a report which is an actual price quote for a specific product, however, the report requestors wish to see a second page of the report which is text and a picture embedded into an Excel spreadsheet.

Does anyone know how I could connect the two, the Crystal report to the Excel data? I've tried an ODBC connection using an Excel driver, that doesn't seem to work. Crystal recognizes the connection, however shows an 'Add Command' instead of the worksheet. Any help would be appreciated.

 

[ianoctdec]

Hi,
Have you tried the 'Access/Excel(DAO)' data source?
I created a subreport based on the Excel file and linked the subreport in the main report.

Dana