Hi,

I am trying to read 2007 format excel sheet(.xlsx) but during import i m getting the following error:

The 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the local machine.

Can somone please tell me the reason and solution of such problem.

Thanks in advance.

You need to install this redistributable on any computer without MS Office:
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

And you need to compile for "x86", not "Any CPU", or else your program will fail on x64 platforms.

-Steve

---

Programming blog: http://nitoprograms.blogspot.com/
Including my TCP/IP .NET Sockets FAQ
MSBuild user? Try out the DynamicExecute task in the MSBuild Extension Pack source; it's currently in Beta so get your comments in!

Thank you Stephen for your earliest reply.

I tried to install this redistributable package on my computer but this installation came up with error message "The installation of this package failed".

My computer is 32 bit processing but still getting the error message.

looking foward for your valuable suggestion in this regard.

Thanks once again.

Hi,
Seems you have asked same question in another post,
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/b70a8fe1-4253-4043-a9c0-98b4e369821c
doesn't the answer fit for you?

Thanks,
Eric

---

Please remember to mark helpful replies as answers and unmark them if they provide no help.