Error (IES 10901) (WIS 10901) when using Excel 2010 file as data source..

[Former Member]

Hello,

I have a annoying issue with using an excel 2010 file as a data source for a universe. Here is the background information.

Setup.

Client: Laptop running Win XP 32bit, Client tools installed with SP2 v9 (latest)

Server: Win 2008 x64, BOE 4.0 SP2 v9 (latest)

Task:

1. On Client, with information design tool, created Project, DB Connection, Data foundation using an excel source on a share
server\share\data.xlsx

2.. Published everything to Repository

3. Try to load univerise in Web Intelligence via creating a new report. I Drag accross the dimensions. When i go to preview data recieve error

 Database error: [Microsoft][ODBC Excel Driver] External table is not in the expected format.. (IES 10901) (WIS 10901) 

4. If i change the excel file to a 2003 format *.xls it all works correctly. Issue being that 2003 cannot hold as much data as a 2010 file so i need to use 2010.

Extra Notes:

1. Both the client and server have the latest Access drivers http://www.microsoft.com/download/en/details.aspx?id=13255

2. Both client and server have a system DSN setup using the 32bit ODBC, same DSN names to the network share.

3. The data excel source sits on the server on a share.

4. I am believing that the isssue is within the area of BOE as when you connect to the excel file via ODBC using crystal 2011, you need to right click on the connection and tick "System Tables" to be able to use the excel 2010 file. The BOE Information design tool does not seem to have this option??

Any advice with this would be great?

thanks

david

[Former Member]

Issue Resolved:

Install

Access Database Engine 2010 Service Pack 1 on the server

http://support.microsoft.com/kb/2460011

Reboot server once completed.