UltraEdit will open CSV file with no limits. But, it is not free either.
Joseph Biran ____________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Close Sent: Friday, August 01, 2008 7:44 AM To: [email protected] Subject: [amibroker] Reading and Writing Large CSVs I did an explore which wound up having 432,830 rows (8900+ symbols, monthly, from 2004 to present. It took it 5 min 0 sec to save to disk. Can someone confirm the following for me: I assume that the resulting csv file will have 432,830 rows in it--is that correct? I discovered that I can only "see" 65536 rows because that is all that my Excel 2002 will open. Does anyone know if there is a reader anywhere that will open or allow viewing of all 432,830 rows. I am aware that Excel 2007 can open over 1 million rows but I am looking for a way to avoid the cost of upgrading. A related question is whether since I own Excel 2002, whether I am eligible for an upgrade price on 2008 vs purchase entire new program; the details on some of the web pages are ambiguous. Any comments? Thanks, Ken
