ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   text file contains more data than will fit for a single worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/230455-text-file-contains-more-data-than-will-fit-single-worksheet.html)

RaY

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.



Roger Govier[_3_]

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.




All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com