Solved

Sql server 2008 R2 excel output reach limit help

Posted on 2012-03-09
6
423 Views
Last Modified: 2012-06-27
I have a database that is running in windows 2008 R2, I have users  who are pulling reports and exporting them into an excel file. Each report contains 80,000 records/rows,  outputted to excel does not work as it exceeds the limit. Excel 2007/2010 can go up to over 1 million rows,  how do I get Sql server to out to a excel 2007 format?
0
Comment
Question by:iamuser
  • 3
  • 2
6 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37702845
Can you describe how the users are getting the records? It's not that they put the record in a .xls file instead of .xlsx right? The last one supports more rows.
0
 

Author Comment

by:iamuser
ID: 37702855
It's a visual basic front end that connects to the sql server
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37702914
Can you post details about the error that you're getting? Is it from the vb app?

For testing: can you get data from your sql server using Data->From Other Sources->From SQL Server in Excel 2007/2010 - I expect you don't get the limit problem there, right?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 1

Expert Comment

by:ksparky
ID: 37739004
We were having the same issue and were able to resolve it with a product called Aspose.Cells.  It is a reporting services add-in.  With some simple customization, we have added Excel 2007 exports to our reports and our users are thrilled.
0
 

Accepted Solution

by:
iamuser earned 0 total points
ID: 37742494
we found that the problem was with SSIS reporting and not an excel issue. SQL server 2008R2 has a reporting limited of 65K rows. SQL server 2012 fixes that with 1m rows
0
 

Author Closing Comment

by:iamuser
ID: 37762365
We found it after searching on the net for the longest time
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question