Skip to Content
avatar image
Former Member

Problems connecting an Excel file to a Crystal Report

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 31, 2017 at 05:30 PM
    Add comment
    10|10000 characters needed characters exceeded