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)?