Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
Download access driver from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en.In the connection string, replace "Microsoft.Jet.OLEDB.4.0" with "Microsoft.ACE.OLEDB.12.0".
We had the same issue with a Windows application accessing xls files in code. We run it with Citrix on Windows 2008 64 bit and for us, the suggestion to compile at least the executeable project with the "Platform target" property set to "x86" instead of "Any CPU" was the solution (the only one...