MS Excel Import issue using OLEDB connection in 64 bit Windows 7 OS

Question

0.00/5 (No votes)

See more:

Hi,

I am working in c# windows application, it has microsoft excel import and export features using OLE DB Connection. It has a support of 2003 and 2007 Excels. This feature is working in all Systems which are having 32 bit OS's. But that excel import and export is not working in 64 bit Windows 7 OS. The following error is coming when try to import MS Excel 2007 in Winodws 7 64 bit Operating syste.
"Micosoft OLE DB 12.0 is not registered with local machine".
Could you please help in this issue. I need solution for this urgently

Thanks && Regards,
K.Kedarnadh

Posted 15-Feb-11 20:27pm

k_kedarnadh

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas Krojer · Answer 1 · 2011-02-15T21:54:00

Solution 1

Try this: Compile your application for target cpu x86 -> if it works, I´ll explain why ;)

Posted 15-Feb-11 21:54pm

Thomas Krojer

Wayne Gaylard · Answer 2 · 2011-02-15T22:00:00

First off, this issue is only urgent to you, no-one else. If Access 2007 is not installed on the local machine then you need to install the Office 2007 Connectivity components on to that machine which can be found here[^]

As long as your app is compiled to a 32 bit executable, then the OS shouldn't matter at all.