Solved

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

Posted on 2011-09-15
4
716 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

696 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