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
- May 16 Wed 2007 20:37
handle data with too many rows
close
全站熱搜
留言列表
發表留言