import text file but sop at 65536 row

[Maurice]

I have a problem with an import test file.
The number of max row are 65536 rows,but the file that i
want import is more large than 65536 rows.
Have you an answer ?

tks a lot !
Maurice

 

[Bill Lunney]

Whatever you do one thing is certain and that is the maximum number of rows
cannot be increased.

You'll have to:

- Break the data up into chunks and import bit at a time or send to
individual worksheets
- Open the file (assuming it's txt) for reading and selectively decide which
rows to import to a worksheet based on some criteria (assuming this is
possible)



--
Regards,


Bill Lunney
www.billlunney.com

 

[1907]

tks for your ansewer,
but how can i decide some criteria to import file when i must import all
contenenets of file *.csv ?

 

[Random]

I think you can connect to the csv with a pivot table. This will
allow you to pick and choose what you want to bring in. It will also
allow you to examine all of the records at once(not on screen of
course).