Using Excel Data in Report

[Krusher]

Ok folks,
No matter which way I try this (using ODBC, DAO, etc..) I end up getting this error message while trying to connect to an excel file in Crystal Reports:

Logon Failed.
Details: DAO Error Code: 0xbd5
Source: DAO.DbEngine
Description: Not a valid account name or password

And interesting enough, when I tested this from my PC at home, I was able to successfully use excel as a data source in my report.

I am using Windows XP, with Crystal Reports 10, and Microsoft Office XPSP2. Any thoughts would be GREATLY appreciated!!!

-K

 

[fredp1]

Hi,
I'm not a frequent user any more.... I've tested it with CR10 v10.0.5.628, Excel 2003 v11.6355.6568(sp1), Win XPsp2 and it works fine with a dao connection.
In the past I found that MDAC can be a bit of a issue.
Download the lastest from the Micosoft web site.
Also check your service packs with Crystal too.

Fred

Cheers
Fred