SQL Server 2000 - utility to execute SELECT and save to CSV

Just wrote a very quick and dirty utility to allow a SELECT from a SQL Server database and save to CSV.  It was for a one off data extraction for a client for a query not currently in the main web based application.  Due to using MSDE there are no SQL client tools to use to do this job, and I didn't have the MSDE manager at hand.

Anyway full details and source code for the utility are now at http://codecorner.tigernews.co.uk/codecorner/SQL2000selecttocsvutility.html.

Print | posted on Thursday, August 25, 2005 3:50 PM

Comments on this post

# re: SQL Server 2000 - utility to execute SELECT and save to CSV

Requesting Gravatar...
Your software save me a lot of time and work! You're my hero of the day!

Thanks for distributing!
Left by David Laperle on Dec 20, 2005 2:35 PM

# re: SQL Server 2000 - utility to execute SELECT and save to CSV

Requesting Gravatar...
great utility, I convert it to VS 2005 and added a checkbox to make it optional to include field names. Thanks a gain for your conribution. by the way, it also worked with SQL 2005.

A.H.
Left by A. H. on Aug 31, 2006 9:18 PM

# re: SQL Server 2000 - utility to execute SELECT and save to CSV

Requesting Gravatar...
Hi, just looking for some code
Left by Luis Borja on Jul 19, 2007 2:31 PM

# re: SQL Server 2000 - utility to execute SELECT and save to CSV

Requesting Gravatar...
I was just going to write something quick to export to csv and like you was prolly only going to use it once or twice. Thanks so much for saving me the bother. Yours works brilliant. :D
Left by SteG on Sep 23, 2009 1:54 PM

Your comment:

 (will show your gravatar)