Using Excel as database 1

[amoeba102]

I've seen several other posts here, but none seem to give the exact set of problems I get. Using CR9 and Excel 2002.

In Excel I have done the highlight and insert/name/define to give the worksheet area a name. I have also named each field.

Then I set up an ODBC file dsn for Microsoft Excel.

In CR go to database expert and click on ODBC/make new connection and navigate to the appropriate file DSN. It finds it, and then all it gives me is an 'add command' box.

Where am I going wrong?

 

[jymm]

I have always had more luck with Crystal going into 'Create new connection' and then 'Access/Excel DAO' instead of ODBC to get to an excel file --- works pretty slick that way

 

[amoeba102]

Talk about simple. Wow! Thanks

 

[keg3]

I'm using CR10 and am having a probem using an excel source. I can add the excel file to a report that is already using a DB2 database and then link the 2 "tables" ok. But when I try to use the fields from the excel file, no data is returned (without using the field on the report, the data displays properly).

I noticed that the excel fields are defined at string[255]. It is almost like Crystal is not recognizing that the values are the same since the lengths are different.

Any suggestions? Thanks.