Importing Excel issue on IIS7.0

Question

0.00/5 (No votes)

See more:

Hello everyone,

I'm stuck with a problem.

I have a web form which imports data from an excel sheet and displays it on gridview.
It works fine on IIS6.0 but when deployed to server which has IIS 7.0 installed on it with windows Vista, it is not importing the data.

Any suggestions/solutions?

I am using OLEDB object to import the data from Excel.
Is there any other way to import data so that conflict of IIS 7.0 is resolved?

Thank you.

Posted 2-Feb-11 22:01pm

ahsan sarfraz

Updated 2-Feb-11 22:23pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 3-Feb-11 4:23am

Edited for Grammar, Syntax and Readability.

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)

**Dalek Dave** · Accepted Answer · 2011-02-02T22:27:00

Solution 1

This is a known issue.
This Link[^] may help.

There are several problems, depending on your methodology, but hopefully this will help.

Posted 2-Feb-11 22:27pm

Dalek Dave

Comments

ahsan sarfraz 3-Feb-11 5:21am

the link is not working its broken :(

Dalek Dave 3-Feb-11 5:25am

No, working perfectly well from here.

ahsan sarfraz 3-Feb-11 5:42am

sorry there was problem with internet.thankyou. but this is not the logic i am using. I am using OLEDB object to make a connection with Excel file and then read it.any other possible solution?

Dalek Dave 3-Feb-11 5:46am

http://stackoverflow.com/questions/3151551/asp-net-oledb-code-breaks-when-deployed-on-iis7

Is an OLEDB response.

ahsan sarfraz 3-Feb-11 6:30am

thankyou for your concern. :)

ahsan sarfraz 3-Feb-11 6:50am

http://www.codeproject.com/KB/office/ExcelReader.aspx

used this dll it worked great :)...

thankyou Liu Junfeng you saved the day.