![]() |
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 |
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