Reading in text file that is more than 65536 rows

G

Graham Whitehead

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split a text file with more than 65536 lines over many worksheets 4
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
Importing Text File with more than 65536 rows 4
Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row>65536 4
Splitting data on sheets for more than 65536 rows... 1
how do I import a CSV file with more than 65536 rows 9
Pivot Table Type Mismatch when More than 65536 rows 1
export a text file which more than 65536 rows into excel 2

Top