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

Posted on 2011-10-26
Last Modified: 2012-05-12
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)?
Question by:bejhan
    1 Comment
    LVL 92

    Accepted Solution

    >>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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now