Facing issues in extracting 80k rows into excel using SSRS 2008 R2 (looking for fix)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Facing issues in extracting 80k rows into...

Facing issues in extracting 80k rows into excel using SSRS 2008 R2 (looking for fix)

Rate Topic

Display Mode

Topic Options

Author

Message

saxena200

Posted Monday, February 11, 2013 12:06 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 11, 2013 3:36 AM
Points: 24, Visits: 81

getting an error which says no. of rows cannot exceed 65k in order to extract to excel.

Post #1418592

karl 93387

Posted Monday, February 11, 2013 12:30 PM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:37 AM
Points: 58, Visits: 67

Prior to Excel 2007, the limit was 65K. Are you running a pre-2007 version?

Post #1418601

maddyk.madhan

Posted Monday, February 11, 2013 10:44 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 5:02 AM
Points: 1, Visits: 83

Hi

check out below link

http://msbitips.wordpress.com/2012/10/18/solution-for-issue-max-65536-rows-limitation-while-exporting-ssrs-report-to-excel-2003/

Post #1418753

« Prev Topic | Next Topic »

Permissions