+ Reply to Thread
Results 1 to 2 of 2

Size Limits

  1. #1
    Olivia Towery
    Guest

    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



  2. #2
    Pete_UK
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1