a91173f0   
   From: esquel@sommarskog.se   
      
   sal21 (gss.italy@iol.it) writes:   
   > Please fast way export from Sql Server table to delimited text ";"   
   > with ado and vb6.   
      
   You can use BCP:   
      
      bcp db.dbo.tbl out file.txt -c -t; -T -S Server   
      
   First argument is table name in three-part notations.   
      
   Second argument is the direction.   
      
   Third argument is the filename.   
      
   -c means that you want character output, ANSI format. Use -w if you want a   
   Unicode file.   
      
   -t; specifies the field delimiter.   
      
   -T specifies Windows authentication. Use -U and -P for SQL authentication.   
      
   Note that BCP must be installed on the client machine. If this is not   
   feasible, the simplest may be to just get the recordset and format it in   
   ADO. There is an API for bulk copy, but it's ODBC, and not accessible   
   directly from VB6.   
      
   --   
   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   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)