Skip to Content

Problems connecting an Excel file to a Crystal Report

Oct 30, 2017 at 09:01 PM


avatar image

Last week I tried to refresh a crystal report which is linked to an Excel file and I got an error message.

I opened the crystal report --> selected lighting bolt to refresh --> the "access/Excel DAO window" popped up with the database auto populated and database type auto populated to Excel 3.0. I selected FINISH and the error message came up.

Error Message Logon failed

Detail: DAO error code 0xcca

Source DAO workspace

Description: external table is not in expected format

Since I did not create the report or the connection, I am not sure how to fix. Any assistance would be greatly appreciated. Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Oct 31, 2017 at 05:30 PM
10 |10000 characters needed characters left characters exceeded