DAO Error Code:External table is not in the Expected format

 I found this Error while connecting to Excel file in Crystal Report 2008 .

Some times if the Excel File is accepted at very beginning you may play around the database fields in crystal report. But later if you modify the Excel file you might get this Error "External table is not in the expected format".

 

Solution:

This Problem arises when Crystal Report doesn't recognise higher versions of Excel such as 2010

So It is Advised to save the Excel file in lower version i.e Microsoft Excel(97-2003).

Which is accepted by Crystal Report.

Error:

It's that Bussiness Objects only supports that version (97,5.0/95) of Excel.

Solution: