Parse Excel 2007 using Data Access Engine
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:
Code:
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:
Code:
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?
Re: Parse Excel 2007 using Data Access Engine
Do the clients have the same version of Excell?
Re: Parse Excel 2007 using Data Access Engine
I tried to install the same version of excel but still that's the message I received:
Code:
External table is not in the expected format.
Re: Parse Excel 2007 using Data Access Engine
Back up his spreadsheet, copy yours to his computer. Does it work?