• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 745
  • Last Modified:

Microsoft.Jet.OLEDB.4.0 on 64-bit servers?

I am using Provider=Microsoft.Jet.OLEDB.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?
0
conrad2010
Asked:
conrad2010
  • 2
1 Solution
 
Shaun KlineLead Software EngineerCommented:
This article describes Microsoft's approach to Jet drivers: http://blogs.msdn.com/b/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx

From experience, we could not find a direct way to use JET 32-bit drivers on SQL Server 64-bit.
0
 
conrad2010Author Commented:
Are you familiar with something that does the same? I would need a 64 bit solution as soon as possible...
0
 
Jacques Bourgeois (James Burger)PresidentCommented:
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.
0
 
Shaun KlineLead Software EngineerCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now