Solved

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

Posted on 2011-09-15
4
707 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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now