External table is not in the expected format 1

[SWarne]

I am trying to import an csv file as Excel file into crystal reports (version XI) and running the report. I am getting the following error

Logon Failed
Details: DAO error code:0xcca
Source: DAO.workspace
Description: External table is not in the expected format

I am using crystal reports XI on windows XP platform.


Can anyone please throw some light on fixing this problem?>
Is there anyway I can import this csv file into crystal reports order to run the report?

Thanks, Shane

 

[synapsevampire]

A CSV isn't the same as Excel format, it should error.

You can import the file into Excel first and then use it, or you can set an ODBC connection to the CSV file.

-k