[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Reading and Writing Large CSVs



PureBytes Links

Trading Reference Links

You can use MS Access.......so long as the file is less than 2G

--- On Fri, 8/1/08, Ken Close <ken45140@xxxxxxxxx> wrote:
From: Ken Close <ken45140@xxxxxxxxx>
Subject: [amibroker] Reading and Writing Large CSVs
To: amibroker@xxxxxxxxxxxxxxx
Date: Friday, August 1, 2008, 8:43 PM

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

__._,_.___

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___