Solved

Sql server 2008 R2 excel output reach limit help

Posted on 2012-03-09
6
430 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 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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 documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

749 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