Re: [amibroker] Reading and Writing Large CSVs

[malc fiveeightninenine <malc5899@xxxxxxxxx>]

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

__,_._,___