Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing text files with more than 65,536 rows (Excel 97 or 2000)

    I'd like to know if anyone knows of an add-in or a macro that would allow one to import large text files (tab delimited data files) that have more than 65,536 rows or data. In other words, if I wanted to import a huge file, with about 200,000 rows of data into Excel, how can I do it such that each new block of 65,536 rows is appended to a new worksheet?

    Drew

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing text files with more than 65,536 rows (Excel 97 or 2000)

    See <!post=xl,87591>Post 87591<!/post>.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing text files with more than 65,536 rows (Excel 97 or 2000)

    Thanks for the prompt response. I absolutely love this forum. It is better than any book or online help system. Anyway, I will have to try some of the ideas that were covered in that other thread.

    <font color=red>Thanks again!</font color=red>

    Drew

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing text files with more than 65,536 rows (Excel 97 or 2000)

    I had a similar situation, where I had to take a linear list of values from a file and tabulate them in a spreadsheet. The linear file was frequently greater than 65536 lines.

    My original approach was: import the whole thing, then rummage through the imported text with VBA code, etc.

    My current approach is: use VBA to open the file, read one line at a time, tabulate that line's value into an array, read the next line, etc. When the end of file is reached, close the file, then dump the resulting array (which is significantly fewer than 65536 rows tall) into the worksheet.

    Perhaps the same approach would be useful for you.

Posting Permissions

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