close

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
------------------------------------------------------------------------
hurriance's Profile: www.excelforum.com/member.php...oamp;userid=30882
View this thread: www.excelforum.com/showthread...hreadid=505624
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.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=505624hurriance,

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

Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;hurriancequot; 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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()