exclude data already imported in excel

As the subject says...
when importing a text file with more then 65536 records i get this message:
"the text file contains more data than will fit on a single worksheet. you
can import the rest of the data by repeating the import operation on another
worksheet and using the text import wizzard to exclude data already impotred
in excel"

but i carnt figure it out.

has anyone got the answer?

A spreadsheet is not infinite in size; it maxes out at 65,536 rows, so you
will not be able to get all of your data onto one worksheet. The message is
telling you that if you want to store the rest of your data you'll have to
put it in a separate worksheet (tab).

The way you would bring the rest of your data into excel (in the second
worksheet) is to open the second (blank) worksheet, then select the Data >
Import External Data > Import Data options, then when point Excel to the text
file. Then the Import Wizard appears, and provides you with the opportunity
to customize the import. Since you've already stored the first 65,536 rows
in the first tab you'll want to skip those rows and begin with row 65,537 in
this worksheet, so at the prompt "Start import at row:" you'll enter 65537;
you'll be able to store your next 65,536 rows in the second tab, and repeat
as needed.

A word of caution about performance in a spreadsheet this large - it's going
to be a bear, and be sure to save often.


Hope this helps...


"Ashley Bowles" wrote:

> As the subject says...
> when importing a text file with more then 65536 records i get this message:
> "the text file contains more data than will fit on a single worksheet. you
> can import the rest of the data by repeating the import operation on another
> worksheet and using the text import wizzard to exclude data already impotred
> in excel"
>
> but i carnt figure it out.
>
> has anyone got the answer?

I attempted to do the operation to continue my import on to the next worksheet, but I get the error "Integer is not valid". Office 2003 importing text file with more line entries than 65535. I received the message regarding the possibility of excluding data that was already imported, but I don't see the option available.

I have Excel 2007, and I'm trying to import a CSV file that has 1,643,761 lines.
The max number of lines that Excel 2007 can import on one sheet is 1,048,576, and my investigations so far suggests that after importing the first sheet, if I open another sheet, and use the import wizard, in the first dialog box where it asks me from which row to start importing from, if I type in 1048577, the rest of the file should import into the new work sheet, but I found that it only import one or two more lines!!!
Does anyone know how I can import the rest please?