Import Excel to SQL Server 2005 using Sqlbulkupload

Question

I want to upload excel file using SqlBulkCopy into a SQL Server 2005 table. My excel file size is 43MB. When I am uploading this file it will display error message that

The request filtering module is configured to deny a request that exceeds the request content length.

My web.config file setting is

<httpRuntime executionTimeout="12000" maxRequestLength="2097151" 
             useFullyQualifiedRedirectUrl="false" minFreeThreads="8" 
             minLocalRequestFreeThreads="4" appRequestQueueLimit="100"/>

Thanks in advance.

Remus Rusanu · Accepted Answer · 2010-12-21 06:03:10Z

1

maxAllowedContentLength:

Optional uint attribute.

Specifies the maximum length of content in a request, in bytes.

The default value is 30000000.

Not that this has anything to do with SQL Server or bulk copy...

answered Dec 21, 2010 at 6:03

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jayesh Over a year ago

I have tried maxAllowedContentLength but error : Unrecognized attribute 'maxAllowedContentLength'. My IIS version is : 7.5.7600.16385

marc_s Over a year ago

@Jayesh: if this answer solved your problem, please accept it as the "right" answer. This will encourage folks to continue to help you.

Collectives™ on Stack Overflow

Import Excel to SQL Server 2005 using Sqlbulkupload

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related