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

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

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

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