From: esquel@sommarskog.se   
      
   Cathy (Cathy@Nospam.com) writes:   
   > I was just looking at BCP, struggled a bit, got most of it working in the   
   > end, but still not quite the same format.   
      
   So what was wrong with the format?   
      
   > I was in fact hoping there was a way I could specify outfile as can be   
   > done in MySQL but I dont seem to get this option in MSSMSE   
      
   I don't know about MySQL, but SSMS is just a client tool for interactive   
   queries.   
      
   There is also the Export/Import wizard which you find the program   
   group for SQL Server.   
      
   --   
   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)