Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine

Rodney Johnson

Hello,

I am working on converting an xlsx file to csv. I cut and pasted some code from Yuan Wang from the following URL

http://www.c-sharpcorner.com/UploadFile/yuanwang200409/102242008174401PM/1.aspx

When the code gets to the statement
conn.Open(); I get the error message "Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine"

I do not know what Jet.OLEDB.4.0 is. Is this something I need to download and install and if so, do I need to be careful about the 32bit vs 64 bit OS; I have 64.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prabhu Raja15y ago
Accepted answer
Hi Rodney,

Click the link, it may help you.

Use these Lines if you want to know latest jet driver releases and download

Data Access Technology

------------------------------------------------------------

Is this post helps you, then mark as "Correct Answer"
anil babu13y ago
Hi i am using Windows server 2008 R2,Vs 2012 I am taking the project Cloud ASP.net webrole template)
I am getting the following error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Satish Bhat15y ago
Are you running your application on x64 or x86 version of Windows?

If your application is targetting 64bit version, currently there is no 64-bit version of Jet driver.

So I would suggest changing the Platform Target build option for your application to target x86 rather than Any CPU.

Or

Microsoft has released a 64 bit compatible 2010 Office System Driver which can be used as replacement for the traditional Microsoft.Jet.OLEDB.4.0 driver.

Please refer the recent thread http://www.c-sharpcorner.com/Forums/Thread/139158/the-microsoft-jet-oledb-4-0-provider-is-not-registered.aspx.
Prabhu Raja15y ago
Hi Rodney,