Please fast way export from Sql Server table to delimited text ";"
with ado and vb6.
Tks

sal21 (gss.italy (AT) iol (DOT) it) writes:
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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx