<< SQL Server 2005 June CTP | Home

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

Feedback

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

left by David Laperle at 12/20/2005 2:35 PM Gravatar
Your software save me a lot of time and work! You're my hero of the day!

Thanks for distributing!

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

left by A. H. at 8/31/2006 9:18 PM 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.

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

left by Luis Borja at 7/19/2007 2:31 PM Gravatar
Hi, just looking for some code
Title  
Name
Email (never displayed)
Url
Comments   
Please add 7 and 2 and type the answer here:
Copyright © Liam Westley