Thanks, Gary.

As you likely know, the code on that post cycles through importing one row
at a time, so as it says, it will run a good while.

I was hoping that there was a way to read the size of the file, or
preferably, the number of lines in the file, and import half of it as a chunk.

But perhaps not.

Thanks.

"Gary Keramidas" wrote:

see if this will help

http://support.microsoft.com/default...b;en-us;120596

--


Gary


"mark" wrote in message
...
Hello.

I have a text file which has over 65536 rows.

I'd like to import the whole thing into Excel... multiple sheets is fine.

So, I need to put the first 65k+ (or half, it doesn't matter) rows on one
sheet, and the rest on another. I could do that manually, easy enough,
but
it will need to be done again, with data that will change, etc.

To do that programatically, I could open the file and walk through reading
and placing the lines.

My question is if anyone has a good suggestion as to how to do that more
quickly than reading through over 65k lines individually... a method to
read
half of the file in on one sheet, and the second half of the file in on
another sheet. I think it's safe to assume, for this purpose, that it
will
never have more rows than in two sheets.

Thanks.
Mark