Reading in text file that is more than 65536 rows
 

Hi,

I have written some code that takes a large text file, performs a bunch of
manipulations and then puts the data in to a pivot table. This works fine
on 2000, 2003 and 2007. However, when the text file is more than 65536 rows
then obviously 2000 and 2003 have a problem - it works fine on 2007 however.
So is there a way to read in the text file and make it stop at 65536 rows
and put the rest onto another worksheet? This would be particularly useful
as the client I have written this for does not want to purchase 2007 if at
all avoidable.

Thanks in advance

Reading in text file that is more than 65536 rows
 

Hi,

Chip Pearson describes how to do that here

http://www.cpearson.com/excel/ImportBigFiles.aspx

Mike

"Graham Whitehead" wrote:

Hi,

I have written some code that takes a large text file, performs a bunch of
manipulations and then puts the data in to a pivot table. This works fine
on 2000, 2003 and 2007. However, when the text file is more than 65536 rows
then obviously 2000 and 2003 have a problem - it works fine on 2007 however.
So is there a way to read in the text file and make it stop at 65536 rows
and put the rest onto another worksheet? This would be particularly useful
as the client I have written this for does not want to purchase 2007 if at
all avoidable.

Thanks in advance