Parse Excel 2007 using Data Access Engine

[jsc0624]

Hi Guys,

I have an application that can parse the data in Excel 2007.
I have installed this driver in my development pc:
2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/downloads/e...displaylang=en

And use this connection strings:

string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";

It is just working fine in my development pc. But after I have deployed the application to my clients pc, it no longer works. The error message is:

External table is not in the expected format.

What components do i need to include in my deployment setup? Or is there a software I need to install in my clients pc?

[Lightning]

Do the clients have the same version of Excell?

[jsc0624]

I tried to install the same version of excel but still that's the message I received:

External table is not in the expected format.

[Lord_Rat]

Back up his spreadsheet, copy yours to his computer. Does it work?