Size Limits

[Olivia Towery]

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?

 

[Pete_UK]

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