handle data with too many rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hurriance - 27 Jan 2006 04:35 GMT

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?

Signature

hurriance

Reply to this Message

wjohnson - 27 Jan 2006 05:20 GMT

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.

Signature

wjohnson

Reply to this Message

Jim Cone - 27 Jan 2006 16:02 GMT

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?

Signature

hurriance

Reply to this Message