I've gotta agree with Grant... doing partial table restores for a given Client would make some serious sucking sounds.  Having 1 database per client also has the advantages of extreme security...

p.s.  Almost without exception, I load files to a staging table first so that I can validate data, check for duplicates, etc, yada, yada.  With that in mind, I also...

Between knowing that day "0" is the first of January, 1900 and that day was a Monday along with a little integer math and a little direct date math, it...

I was able to duplicate the error even after adding the / n.  Looking...

That should do... let me see what gives.

Ah.  Ok.  Speaking of tables, can you post the CREATE TABLE statement for the table this file is supposed to go into?  That way, I can do some testing.

Also, since this is a really clean and consistent text file, why are you bothering with a BCP format file to begin with?