ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing data from a Text File, Not enough lines? (https://www.excelbanter.com/excel-programming/300061-importing-data-text-file-not-enough-lines.html)

baldyguy

Importing data from a Text File, Not enough lines?
 
Hello everyone,

I have a text file that I need to import on excel that has 221,63
lines. When I try to view it in excel it only lets me view up t
65,536, and I think that is the max excel can view? Can anyone tell m
how I can view the whole 221,630 lines in excel? Thank

--
Message posted from http://www.ExcelForum.com


Ron de Bruin

Importing data from a Text File, Not enough lines?
 
Hi baldyguy

http://support.microsoft.com/default...;EN-US;q120596
XL: Importing Text Files Larger Than ???? Rows

--
Regards Ron de Bruin
http://www.rondebruin.nl


"baldyguy " wrote in message ...
Hello everyone,

I have a text file that I need to import on excel that has 221,630
lines. When I try to view it in excel it only lets me view up to
65,536, and I think that is the max excel can view? Can anyone tell me
how I can view the whole 221,630 lines in excel? Thanks


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com