Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
handle data with too many rows
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: http://www.excelforum.com/member.php...o&userid=30882 View this thread: http://www.excelforum.com/showthread...hreadid=505624 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
handle data with too many rows
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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=505624 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
handle data with too many 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? -- hurriance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) |