[dba-SQLServer] Export data sets to CSV files

Here's an article that might help...

http://www.sqlteam.com/item.asp?ItemID=4722 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, May 16, 2007 8:53 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Export data sets to CSV files

I posted a question about breaking a table down into "small" chunks for
export to a csv file.  I got a response about building the SELECT query
(which I can find).  The next piece that I need assistance with is getting
that exported out to the text file.  

For the data import, I simply used a stored procedure which used a BULK
INSERT from a file into a table, using a specified field and record
delimiter.  Works GREAT!!!  What is the reverse of a BULK INSERT?

John W. Colby
Colby Consulting
www.ColbyConsulting.com