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?
--
hurriance