Microsoft.Jet.OLEDB.4.0 provider is not registered

c# file-upload xls oledbexception
prashiddha picture prashiddha · Sep 22, 2011 · Viewed 9k times · Source

Hi I am getting a problem like this while uploading filetype .xls "Error in excel file:The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

I am using following system versions:

  1. 64-bit Operating System( Windows 7).
  2. 32-bit Office of which I have attached screen shot.
  3. Trying these for .aspx pages in C#.

I have tried following:

  1. Downloading 32 and 64 bits of Microsoft.Jet.OLEDB.4.0 from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255.

  2. Tried IIS Edit Application Pool > Advanced Setting > Enable 32-Bit Applications :True.

BUT BOTH OF THEM ARE NOT WORKING FOR ME. DO ANYONE HAVE GOT AN IDEA?

containt of Image mentiontioned are here:

Microsoft Office Professional Plus 2010

Version: 14.0.4760.1000(32-bit)

Answer

Simon Mourier picture Simon Mourier · Sep 22, 2011

If you installed Office 32-bit, then you need to install the Access Database Engine 2010 64-bit on the machine, but there is a trick to install it. See here about the 'passive' argument: Microsoft Access Database Engine 2010 Redistributable

Related questions

How to increase the max upload file size in ASP.NET?

I have a form that excepts a file upload in ASP.NET. I need to increase the max upload size to above the 4 MB default. I have found in certain places referencing the below code at msdn. [ConfigurationPropertyAttribute("maxRequestLength", DefaultValue = )] …

Read More
Upload file to FTP using C#

I try upload a file to an FTP-server with C#. The file is uploaded but with zero bytes. private void button2_Click(object sender, EventArgs e) { var dirPath = @"C:/Documents and Settings/sander.GD/Bureaublad/test/"; ftp ftpClient = new ftp("…

Read More
Byte[] to ASCII

I received the contents of a text file returned in binary values: Byte[] buf = new Byte[size]; stream = File.InputStream; stream.Read(buf, 0, size); How can I convert this to ASCII?

Read More