Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
searching a text file and importing selected data brian Excel Discussion (Misc queries) 0 October 30th 07 08:44 PM
importing text file data into excel GradStudent N need Excel Discussion (Misc queries) 1 September 7th 07 09:44 AM
Can I automatically replace data when importing a text file? Jake New Users to Excel 1 June 6th 06 03:09 PM
character restrictions when importing data from a text file richtea Excel Discussion (Misc queries) 3 September 3rd 05 04:13 PM
importing text file, removing data and outputting new text file Pal Excel Programming 8 February 27th 04 08:32 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"