import tekst 65536 rows
 

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

import tekst 65536 rows
 

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

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

import tekst 65536 rows
 

Tom,

Well I started out to reference 119770, but it somehow didn't end up that way. <g

Thanks for being more alert than I am today.

Regards,
Jim Cone


"Tom Ogilvy" wrote in message
...
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