conrad2010
asked on
Microsoft.Jet.OLEDB.4.0 on 64-bit servers?
I am using Provider=Microsoft.Jet.OLE DB.4.0 to open up Excel files and import them... my question is this: Does Microsoft.Jet.OLEDB.4.0 work on 64-bit servers?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use the JET on a 64-bit computer, but the application that calls it should be compiled as a 32-bits application. JET is not recognized by 64-bits applications.
You can try using the 2007 Office System Driver: Data Connectivity Components. It is supposed to be the replacement to Jet. I haven't worked with it, but from the articles I have read, it has a 64-bit version.
http://www.microsoft.com/download/en/details.aspx?id=23734
http://www.microsoft.com/download/en/details.aspx?id=23734
ASKER