[AccessD] New database from hell

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
>