Solved

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

Posted on 2011-09-15
4
715 Views
Last Modified: 2013-12-17
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
Comment
Question by:conrad2010
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points
ID: 36545756
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
 

Author Closing Comment

by:conrad2010
ID: 36545892
Are you familiar with something that does the same? I would need a 64 bit solution as soon as possible...
0
 
LVL 40
ID: 36546287
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
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 36549081
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question