[AccessD] New database from hell

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