Sql server 2008 R2 excel output reach limit help

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?
iamuserAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
iamuserConnect With a Mentor Author Commented:
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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
iamuserAuthor Commented:
It's a visual basic front end that connects to the sql server
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
ksparkyCommented:
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
 
iamuserAuthor Commented:
We found it after searching on the net for the longest time
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.