handle data with too many rows

  • Thread starter Thread starter hurriance
  • Start date Start date
H

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?
 
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.
 
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?
 
Back
Top