excell 2007 & Crystal 11 2

[p658484]

Hi,
I have been using excel 2003 with crystal 11 and now we have excel 2007. When I try to use data from excel 2007 in crystal I am getting a message 'Failed to load database information'. Not sure why? Any help will be appreciated.
Thanks
RM

 

[p658484]

I get a second message as well 'Unknown database connector error'

Thanks
RM

 

[SkipVought]

How is your Excel 2007 workbook specified in your CR connection?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[p658484]

Hello,
Sorry, but not sure where exactly to look for this information. In the ODBC (RDO) it is showing as 'excel files and MS Access Database'.
In OLE DB(ADO) - there is Microsoft Office 12.0 Access Database Engine OLE DB provider

Thanks
RM

 

[SkipVought]

How does CR know WHICH WORKBOOK it is connected to?

How would YOU connect to a different workbook?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hilfy]

Crystal 11 will not read Excel 2007. Since it came out long before Office 2011, this is not a surprise. You'll need Crystal 2011 if you want to read Excel 2007 workbooks.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[SkipVought]

You could save your Excel 2007 workbook as an Excel '97-2003 workbook, and your existing connection might work. Keep in ming that in doing that, you will have BOTH a 2007 and a '97-2003 workbook.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[p658484]

Thanks for all your feedback. Unfortunately my excel data has over 200,000 rows, so can't save it in excel 2003.
Thanks
RM

 

[SkipVought]

Hmmmm??? How do these two statements play?

I have been using excel 2003 with crystal 11 and now we have excel 2007

Unfortunately my excel data has over 200,000 rows, so can't save it in excel 2003.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}