ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Size Limits (https://www.excelbanter.com/excel-worksheet-functions/86958-size-limits.html)

Olivia Towery

Size Limits
 
I use the Excel Object to write a workbook from a sql db each month. This
month the data was extensive and it seemed to quit writing after so many
lines. Is there a way to program the script to continue to write regardless
of size?

--
Olivia Towery
Tower Internet Management



Pete_UK

Size Limits
 
There is a limit of 65536 rows in any worksheet. You would need to
count the number of rows written from your database, and when you
exceed this number start writing to another worksheet (or workbook).

Hope this helps.

Pete



All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com