Importing more than 65359 rows of data

J

jgorski

I know there is a way to make excel accept more data. I have done it o
other computers but have forgotten the command. Can someone pleas
remind me how.

Thanks,

Jef
 
D

Dave Peterson

Use multiple worksheets????



jgorski < said:
I know there is a way to make excel accept more data. I have done it on
other computers but have forgotten the command. Can someone please
remind me how.

Thanks,

Jeff
Click to expand...
 
N

Norman Jones

Hi Igorski,

With XL97 onwards the number of rows in a worksheet is limited to 65536
rather than 65539.

Microsoft Knowledge Base Article 120596 ("Importing Text Files Larger Than
16384 Rows"):
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
provides a routine to import data to multiple worksheets.

As indicated in the KB article, you should replace 16384 with 65536 in the
routine - 16384 being the maximum number of rows in an earlier version of
XL.
 
P

Paul

Hi Jeff,

When opening a file and the Text Import Wizard appears,
you can enter a value in the 'Start import at row' box.
The maximum in Excel 2002 is 32767. Excel will then skip
that number of records in the import file. Your sheet will
contain records 32767 to 98302.

Is that any help?

Paul
 
D

Dave Peterson

One more option.

Just use your favorite editor to split your text file into smaller pieces.

Then open each separately.
 
Top