Microsoft.Jet.OLEDB.4.0 - 32bit and 64bit

Question

We are having a 64Bit compatibility problem.  Something that was working in 32 bit is no longer working in 64 bit.  We need a short / Quick solution for the following:

The issue we are having is with the Microsoft.Jet.OLEDB.4.0 driver. We are using this driver to read and write data to the Excel File (Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=YES;").

 

But currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS. The topic titled Deprecated MDAC/WDAC Components in the below given link describes about this issue. It also suggests using a new driver (2007 Office System Driver) as a replacement to the current JET driver. But when I did a quick search about this new driver, it says the 2007 Office System Driver is also currently supported in 32 bit OS versions (need to confirm on this)

Answer 1

Do you test ODBC drivers?

---

With best regards, Yasser Zamani

Answer 2

Hello,

 

Welcome to ADO.NET Data Providers forum!

 

As you said, Microsoft.Jet.OLEDB.4.0 is not supported for 64-bit OS.  Also, currently Office 2007 System Driver is not support 64-bit OS either. 

 

However, I think the 64-bit OLEDB Provider for ODBC might be helpful to you:

http://blogs.msdn.com/data/archive/2008/04/07/64-bit-oledb-provider-for-odbc-msdasql-is-now-available-for-windows-server-2003.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

If you wanto to use the original provider, we need to build the project as x86 instead of x64 or Any CPU in 64bit OS. 

Happy New Year!

 

Best Regards,
Lingzhi Sun

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

On more addition tp Lingzhi's post. I am not sure what exactly you need in terms of functionality, but you could try components for Excel from my web site that are developed in .NET and support both 32- and 64-bit modes.

---

Val Mazur (MVP) http://www.xporttools.net

Answer 4

The 64-bit Microsoft Access Database Engine (Office 2010) is currently in Beta. There is a download available:

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

The other alternative is to compile your app with the x86 option so that it runs in WoW64 (32-bit Windows subsystem).

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 5

Hello,

 

I am writing to check the status of the issue on your side.  Would you mind letting us know the result of the suggestions? 

 

If you need further assistance, please feel free to let me know.   I will be more than happy to be of assistance.

 

Have a nice day!

 

 

Best Regards,
Lingzhi Sun

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 6

The 64-bit Microsoft Access Database Engine (Office 2010) is currently in Beta. There is a download available:

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

The other alternative is to compile your app with the x86 option so that it runs in WoW64 (32-bit Windows subsystem).

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Anyone have got the solution? It is not helpful to my issue, Thanks very much!

Answer 7

There is Microsoft Access Database Engine 2010 http://www.microsoft.com/download/en/details.aspx?id=13255 but my problem is a bit opposite. I have Office 2010 and I believe I do have 64 bit version of the OleDB, but I could not find this C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL so I'm missing 32 bit version of OleDB 12 provider. Do you know where can I get 32 bit version to install on my Windows 7 64 and Office 2010 64 bit? I need 32 bit provider as I'm trying to download Excel files into VFP which is 32 bit application.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 8

You can install either the 2007 or 2010 version. I believe the 2010 version will require the /passive command line argument if the 64-bit version is already installed

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e&displaylang=en

http://www.microsoft.com/download/en/details.aspx?id=13255

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 9

I was able to install AccessDatabaseEngine /passive and it now works great from VFP application. Thanks a lot.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 10

We are having a 64Bit compatibility problem.  Something that was working in 32 bit is no longer working in 64 bit.  We need a short / Quick solution for the following:

The issue we are having is with the Microsoft.Jet.OLEDB.4.0 driver. We are using this driver to read and write data to the Excel File (Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=YES;").

But currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS. The topic titled Deprecated MDAC/WDAC Components in the below given link describes about this issue. It also suggests using a new driver (2007 Office System Driver) as a replacement to the current JET driver. But when I did a quick search about this new driver, it says the 2007 Office System Driver is also currently supported in 32 bit OS versions (need to confirm on this)

Answer 11

Dear Author,

Thank you very much for providing these tips.They were really helpful.I spent lot of time on finding a solution for my problem. 

"I couldnt update the Access database (2007) from Visual Studio(2012),Nothing was written to the database."

My OS is 64 bit.And later I did changed the building configuration as you have said.It worked really well.

Thank you very much for your great job...

Answer 12

It works, but there is a side effect. After install x64 driver as passive, Excel began to show a install wizard every opening.

Answer 13

Do you know what should I do to be able to load Excel xlsx files from VFP application (VFP is 32 bit application).

I have Windows 10 and Office 2016 64 bit installed.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

My TechNet articles