?
Solved

Sql server 2008 R2 excel output reach limit help

Posted on 2012-03-09
6
Medium Priority
?
435 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 38

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 38

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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

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…
How to increase the row limit in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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
Suggested Courses

741 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