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 |
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 |
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 |
All times are GMT +1. The time now is 06:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com