working with large text files
 

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

working with large text files
 

If these records are in an array, you can simply assign a range to them as
opposed to cycling through them.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"mark" wrote:

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

working with large text files
 

If these records are in an array, you can simply assign a range to them as
opposed to cycling through them.

I'm not quite sure if that answers my question or not.

The records are currently in a text file, totally outside of Excel... just a
plain flat file.

Once I get them into Excel, sure, I can assign a range name to them.

But the question was about methods of splitting the flat text file and
getting them into Excel.

working with large text files
 

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

working with large text files
 

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