From: kdicus@dicus.com   
      
   Unreal...  It worked.  How simple was that!!!   
      
   Outstanding!   
      
   Thank you so much.  I've been reading through tons of messages tonight.  It   
   is CLEAR that you are a GOD on here.   
      
   Kurt   
      
      
      
   "Erland Sommarskog"  wrote in message   
   news:Xns9F2970D5C97ECYazorman@127.0.0.1...   
      
   Kurt Dicus (kdicus@dicus.com) writes:   
   > This would be a perfect file!   
   >   
   > IDSTATUSDESCRIPTIONACTIVE   
   > 1activeTest description shorttrue   
   > 2under constructionTest description 2false   
   >   
   > What the file actually looks like.   
   > IDSTATUSDESCRIPTIONACTIVE   
   > 1activeTest   -- it is only the DESCRIPTION field that has the   
   > premature break   
   > description   
   > long stringtrue   
   > 2under constructionTest description 2false   
      
   Have you tried to bulk-load this misfit with BCP or BULK INSERT? I belive   
   that should work. They look for one field at a time, so when they look for   
   the third field, they are looking for tab characters to terminate that   
   field. The CRLF will be consumed as data.   
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)