• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1013
  • Last Modified:

What is the max number of rows you can have in Excel 2010?

What is the max number of rows you can have in Excel 2010?
What is the max numbers of rows you can export from MS Access 2010?
0
Troush2009
Asked:
Troush2009
  • 2
  • 2
  • 2
  • +1
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
In Excel 2003 and earlier the number of rows in a worksheet is 65,536 and the number of columns is 256 making the last cell IV65536. The maximum number of sheets is 1,024. Excel 2007 increased the number of rows to 1,048,576 and the number of columns to 16,385 making the last cell XFD1048576. The maximum number of sheets remains 1,024.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You can export as many rows from Access into Excel as Excel can handle, i.e., 1,048,576.

Kevin
0
 
RunriggerCommented:
There is no maximum number of rows in MS Access, however you do have a maximum size of database - a whopping 2gb, I have had well over 10million rows in a single table.

the number is likely to be restrictive depending on indexes/data types and number of fields!
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
RunriggerCommented:
Clearly exporting from MS Access will be dependent on target file type, a txt file would be unlimited for instance!
0
 
meko72Commented:
I believe in Excel 2010 it is 64,000

http://msdn.microsoft.com/en-us/library/ff700514.aspx

0
 
dottenCommented:
The maximum number of rows Excel can store went up to 1,048,576 rows.  

In regards to row export from Access 2010, the only limitation that I've come across is when exporting to Excel or attempting to copy/past from access/excel.  For some reason, you still can't do more that 65k rows.  
0
 
dottenCommented:
I understand the question regarding Access to be 'maximum rows to export', not 'maximum rows to export to excel'

I was curious and did a little checking.  While there's no apparent upper limit when exporting from Access to a non-excel file, other than what runrigger mentions, there still are obstacles exporting to excel.  I found this from Microsoft Connect:  

http://connect.microsoft.com/LiveMesh/feedback/details/651345/max-rows-exportable-to-excel-from-within-access

Where it says:
"While the number of rows allowed in an Excel spreadsheet increased for Office 2007/2010, Access continues to limit the number of rows allowed to be exported to Excel to 65,000. Therefore, I have to export the data to an XML file, open it from within Excel, then save it as an Excel file. "
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now