You can open large files with Notepad and Wordpad. I have done that to break them into smaller files that will fit on an Excel sheet. That is a pain to do.
Another thing you can do is modify my AFL formula to dump data out in any size block you need then import them into individual Excel sheets. I put an export program in the AFL library that will export EOD and intraday data to a csv file. You could add a counter in the for loop to break that into smaller files, 63K lines or so, close and then open a new file with an extension, a, b, c... and so on. Barry --- In [email protected], "J. Biran" <[EMAIL PROTECTED]> wrote: > > 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 >
