I just did a File, Open of a long text file and all 270,000 rows came in
fine.

If you are "importing" data into an existing sheet, using the Data commands,
you are limited to the rows in that sheet. And if it in the XLS format that
limit is 65k rows.


--
Jim
wrote in message
...
| Thank you guys. My original file is txt file and it does has more than
| 65537 raws.
| After I imported the data, (it only gave me 65537 raws), I can not
| insert more raws, this also happens if I create an empty file, copy
| and past the data..
|
| JLGWhiz , can you be more specific on the import macro? How to check
| it? Thanks.