how can I upload 40 MB excel file in Asp.net

Question

0.00/5 (No votes)

See more:

I can upload 22 mb excel file in asp.net by using sqlbluk method But
when i upload 40 mb file it is not uploaded in database and also i did not get any error.

I have also included the tag in web config to increase the file uploading size in my
application. But it is not working.

suggest me the maximum size of excel file which i can upload in asp.net application
and what is the best way to do this.

The change i had done in web config is given below for your reference

HTML

<httpruntime maxrequestlength="2097151" executiontimeout="36000" />

Posted 31-Oct-11 20:36pm

Rajesh Duraisamy

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)

RaviRanjanKr · Answer 1 · 2011-10-31T20:45:00

Hey! have a look there-[Large file uploads in ASP.NET][^]
from reference :-

XML

<location path="Upload">
    <system.web>
        <httpRuntime executionTimeout="110" maxRequestLength="20000" />
    </system.web>
</location>

and even better to opt below option
A custom HttpHandler can provide a better user experience by displaying upload progress and allowing you to handle a file size problem in a more controlled fashion. Here's a summary from a cursory search:
FileUploader.NET[^]

you can take a look Same suggestion also there-[How to Upload Large Files in ASP.NET][^]

Abhinav S · Answer 2 · 2011-10-31T20:46:00

Solution 2

Large file uploads in ASP.NET[^] discusses some approaches for large files.

Posted 31-Oct-11 20:46pm

Abhinav S