View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default import tekst 65536 rows

Think you have your references mixed up - although that is a good article:

http://support.microsoft.com/?kbid=120596
Importing text files larger than 65536 rows

Think you were citing an article using start line. Perhaps this one:

http://support.microsoft.com/default...b;en-us;119770
Text Import Wizard Maximum Start Row Limitation of 32767

which does have a section entitled:
"Excel 97 -- Importing Text Files with Fewer than 98,303 Rows"


--
Regards,
Tom Ogilvy



"Jim Cone" wrote in message
...
If you have less than 98303 rows, then the following knowledge base

article may help...

http://support.microsoft.com/?kbid=120596
See the section:
" Importing Text Files with Fewer than 98,303 Rows"

Jim Cone
San Francisco, USA



"Reniek" wrote in message
...
Hi,

If I have a txt file with data more than 65536 rows, is it possible to
import into Excell all the data divided into 2 sheets or the part will

be
lost?

Thanks for any advice
IW