Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-09-15
4
Medium Priority
?
733 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 27

Accepted Solution

by:
Shaun Kline earned 2000 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 27

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

879 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