Stuart McLachlan
stuart at lexacorp.com.pg
Fri Mar 23 15:44:54 CDT 2012
My initial search turned up an interesting article: http://blog.mischel.com/2011/12/01/large-text-file-viewers/ After a bit more searching I found this: http://www.baremetalsoft.com/baretail/index.php?app=BareTail&ver=3.50a&date=2006-11-02 The freeware version has a Splash Screen, but that's all. It opened and displayed a chunk from a 15GB binary file instantly. Designed as a WIndows version of the Unix "tail" , it defaults to opening the last block of the file, but you can change that simply with the Configuration/Options screen. Give it a try and tell us how it handles your monster file. -- Stuart On 24 Mar 2012 at 5:58, Stuart McLachlan wrote: > I used to have an old DOS program for reading large files which only read it in chunks at a > time as you wanted to view them. I can't remember its name, but you have got me thinking. > Someone must have written something like that for Windows. I think you've just set me a > challenge :) > > I think I'll go looking for something like that on the web (or maybe write my own if I can't fin > one. It should be fairly simple to do - just get the file size and read and display chunks on > demand). > > -- > Stuart > > > On 23 Mar 2012 at 13:39, jwcolby wrote: > > > I received a new "database from hell" today. This one is actually CSV format. It came with a table > > specification which in no way matches the actual file. However it appears to be importing in with > > just a few minor changes to the default 50 character default field width that the SQL Server import > > wizard uses. > > > > The file came in a 24 gigabyte zip file. Expanded it is 250 gigs. Way to large for even UltraEdit > > (my tried and true champion) to open. So I was unable to preview the data. However I just used the > > SQL Server import wizard to open the file and start looking at it. SQL Server truly is an amazing > > piece of work. > > > > No firm idea yet on the number of rows though I was told well over 100 million. 430 columns. > > > > -- > > John W. Colby > > Colby Consulting > > > > Reality is what refuses to go away > > when you do not believe in it > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >