handle data with too many rows

[hurriance]

I should import a csv file with 70,000 rows into excel and then perform
an auto selection to get the required rows.

However, when I try to import the data, excel said that there are too
much data. What should I do in order to import all the data?

 

[wjohnson]

Split your file, or select approximately 1/3 at a time - and you wont be
able to insert all of you file into 1 sheet anyway - as it exceeds the
max number of excel rows.

 

[Jim Cone]

hurriance,

Here is one way...
http://support.microsoft.com/kb/119770/en-us
"Text Import Wizard..."
Look at the XL 97 section.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"hurriance" wrote in message
I should import a csv file with 70,000 rows into excel and then perform
an auto selection to get the required rows.

However, when I try to import the data, excel said that there are too
much data. What should I do in order to import all the data?