Crystal 8.5 adding excel file as data source

[UHsoccer]

I have several reports looking at an SQL data base. I now want to include an Excel spreadsheet to add additional functionality.

I have looked at the forum, but could not find the answer to the following:

- Can I just access my spreadsheet as is, it has a header.
- When I go to Data base / Add Data base to report. I then see an Excel selection under ODBC. When I select my spreadsheet I get the response "no items found". How do I "ODBC" my spreadsheet?

Would like to get educated on this subject, Thanks in advance

 

[synapsevampire]

This depends on your Excel version, and the layout of the Excel file.

To add an ODBC DSN, go to Control Panel->Administrative Tools and select ODBC and add a new one.

The exact screens vary depending upon your OS.

-k

 

[UHsoccer]

I am using Crystal 8.5 and Excel 2003

I created the Excel ODBC connection and idetified the Excel workbook.

When I go to Crystal, Database / Add Database to report and navigate to the ODBC that I created it only has "No items found"

Is there something I need to do the Excel file itself, I simply defined a header row, filled in relevant data and saved it. I then referenced it in the ODBC creation step