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:

Reasons to Choose Xcelsius

What amazing dashboards you can create with Xcelsius 2008
with its rich UI elements and data connectivity


let’s check some reasons to choose Xcelsius as your dashboarding tool.

•  It’s powerful.
• By using cutting-edge technology, Xcelsius provides the best visualization effect and user experience. With several kinds of data connectivity, such as Web services and XML data, you can connect to almost any kind of data source.
•  It’s easy to use.Xcelsius offers a wide range of UI components such as pie charts, candlestick charts, accordion menu, and maps, and you need simply drag and drop the components to create a professional dashboard.
•  It uses almost everyone’s daily tool, Microsoft Excel, as its direct data source and provides a built-in Excel. In this way, you can easily bind the UI components to a single cell or a range of cells in the Excel spreadsheet.
•  It’s extensible and growing.Xcelsius brings with it a wide range of UI components and data connectivity methods, but sometimes you may encounter a scenario where you need something new. Xcelsius is extensible in that it provides a software development kit (SDK), which you can use to create your custom UI components and data connectivity. 
• Moreover, some companies are working on developing a new component, and there are many active forums about how to use Xcelsius. 

Also, SAP keeps releasing new features to Xcelsius.