[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Is the Excel row limit increase due to the new format (xlsx) or the new application (2007)?

I know the row limit for Excel has been increased drastically from ~65K to ~1 million.
Is this due to the new format they are using (xlsx) or does it have to do with the application?

The reason that I ask is that I migrating a bunch of Access applications from 2003 to 2010.
Previously when exporting tables to Excel, I had to split into multiple sheets within a workbook because of ~65K limit. I would like to stop doing this.
So when I use DoCmd.TransferSpreadsheet, do I need to use the new format (acSpreadsheetTypeExcel12Xml)?
0
bejhan
Asked:
bejhan
1 Solution
 
Patrick MatthewsCommented:
>>So when I use DoCmd.TransferSpreadsheet, do I need to use the new format (acSpreadsheetTypeExcel12Xml)

If you want to export more than 65,536 rows at a time, yes, you do.
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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now