Connect string to Excel office 2013 in C#

Question

0.00/5 (No votes)

See more:

Hi All!
I want to read/write excel file using C #. But I can not connect to Office 2013
Here is my connection string:

C#

OleDbConnection oledbConn;
oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");

Thanks for everyone's help!

Posted 1-Aug-13 16:53pm

Mr.thang

Add a Solution

Comments

Ron Beyer 1-Aug-13 22:59pm

Do you have some kind of question? Description of the error or why you can't connect?

Mr.thang 1-Aug-13 23:19pm

Dear Ron Beyer!
I encounter the following error:
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I do not understand the provider's current Office version!
Thanks!

1 solution

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)

Sushil Mate · Answer 1 · 2013-08-01T17:37:00

Solution 1

You need to install 2007 Office System Driver: Data Connectivity Components.

http://www.microsoft.com/en-us/download/details.aspx?id=23734[^]

Updated:

http://stackoverflow.com/questions/16610940/import-excel-2013-to-vs-microsoft-ace-oledb-12-0-is-not-registered-on-the-local[^]

http://stackoverflow.com/questions/14562587/microsoft-ace-oledb-12-0-provider-can-no-longer-open-mdb-under-windows-8[^]

Posted 1-Aug-13 17:37pm

Sushil Mate

Updated 1-Aug-13 17:59pm

v2

Comments

Mr.thang 1-Aug-13 23:55pm

Hi Sushil Mate!
I'm currently using Office 2013 version.
can I install 2007 Office System Driver?

Sushil Mate 2-Aug-13 0:00am

Please check the update links, you will get idea.

Mr.thang 2-Aug-13 0:12am

Thanks Sushil Mate!
I will try.