Error while importing excel file in asp.net application

Question

0.00/5 (No votes)

See more:

Hi to all,

I have created a form, in which I want to upload a excel file to save data from the file. I have use 'Microsoft.ACE.OLEDB.12.0' Provider.
It work fine on local machine, but when I published same on web, it won't work.
It gives error as:

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

Use code is as follows:

C#

DataTable dtExcel = new DataTable();
string SourceConstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + filename + "';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection con = new OleDbConnection(SourceConstr);
Query = "Select * from [Sheet1$]";
OleDbDataAdapter data = new OleDbDataAdapter(Query, con);
data.Fill(dtExcel);

Please advice is expected.
Thank You

Posted 4-Aug-12 1:03am

Harshad-HBK

Add a Solution

Comments

[no name] 4-Aug-12 7:17am

Is Excel installed on the server computer?

Harshad-HBK 4-Aug-12 7:24am

yes

[no name] 4-Aug-12 7:26am

https://www.google.com/search?q=+%27Microsoft.ACE.OLEDB.12.0%27+provider+is+not+registered+on+the+local+machine&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

2 solutions

Solution 1

There are two possible problems with your code. What if the other person dosent have an english Excel version, then Sheet wont exist.

The other problem could be this:
http://social.msdn.microsoft.com/Forums/nn-NO/exceldev/thread/0f03c2de-3ee2-475f-b6a2-f4efb97de302[^]

Posted 4-Aug-12 11:07am

Kenneth Haugland

Comments

Harshad-HBK 7-Aug-12 3:40am

thanks a lot...

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)

I.explore.code · Accepted Answer · 2012-08-04T14:18:00

in addition to whats been already said and as an alternative to uploading files, you can copy and paste excel data into a text-box in ASP.NET application and then just parse it out, based on delimiters, to a collection. This collection can then be looped over and pushed to the database. Some of the business bulk-import and upload systems that I have written, were written this way. Always works!