View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default REad large txt files

G,

Here is one way...

http://support.microsoft.com/?kbid=120596
"Importing Text Files Larger Than 16384 Rows"

Regards,
Jim Cone
San Francisco, CA

"banavas " wrote in message ...
Dear Friends,
how can I read with excel a txt file that contains more that 65000
rows. Is there a way to store the files in multiple sheets?
Thanks,
G.