Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RaY RaY is offline
external usenet poster
 
Posts: 164
Default text file contains more data than will fit for a single worksheet

I use excel 2003.

I try to import a text file into excel. However the text file contains so
many raws that only the data until raw 65536 can be accepted in excel.

And excel tells I can import the rest of the data by repeating the import
operation on another worksheet and using the text import wizard to exclude
data already imported. But it doesn't work.

Is there anybody who can help me? Thank you very much in advance.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default text file contains more data than will fit for a single worksheet

Hi

What do you mean by "Does not work"?
What happens?
The Import Wizard gives you the option to Start Import at Row ?????

--
Regards
Roger Govier

"Ray" wrote in message
...
I use excel 2003.

I try to import a text file into excel. However the text file contains so
many raws that only the data until raw 65536 can be accepted in excel.

And excel tells I can import the rest of the data by repeating the import
operation on another worksheet and using the text import wizard to exclude
data already imported. But it doesn't work.

Is there anybody who can help me? Thank you very much in advance.


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
Merge Multiple Single Worksheet Excel Files into one file in separ dbguy11 Excel Discussion (Misc queries) 6 April 3rd 23 04:20 PM
export excel colonm to a single text file [email protected] Excel Discussion (Misc queries) 1 December 20th 08 10:36 AM
Single text file imported to multiple worksheets Lynn Bales Excel Worksheet Functions 2 September 21st 06 10:42 PM
Save a single worksheet in Excel as a single file. Dakota New Users to Excel 4 February 22nd 06 04:46 PM
Import text file to a SINGLE ROW? robazefa Excel Discussion (Misc queries) 1 November 2nd 05 05:05 AM


All times are GMT +1. The time now is 03:49 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"