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

Topic

New Reply

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

Reply | Quote

Replies

See Post 87591.

Reply | Quote

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.

Thanks again!

Drew

Reply | Quote

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.

Reply | Quote