How to export data into .csv file thru query

[narasimharao]

Hi,

I have a select query to retrieve the data. I want to export the data into a .csv file in a specified location thru query (Not Manually saving into csv file ).

Kindly suggest me the procedure.

Thanks

[Eric Isaacs]

Here's a useful article on the subject:
http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

[Uri Dimant]

Hi
http://dimantdatabasesolutions.blogspot.com/2007/09/insert-data-into-text-file.html

<Narasimha Rao> wrote in message news:20086110...@yahoo.com...

[shally]

You can try to use the third party add-in. Recently, I downloaded one free data export component. It is very useful to export data into several kinds of format files.
If you are interested in it, you can download it from http://www.e-iceblue.com/Download/download-dataexport-for-net-now.html

>> On Wednesday, June 11, 2008 12:34 AM Uri Dimant wrote:

>> Hi
>> http://dimantdatabasesolutions.blogspot.com/2007/09/insert-data-into-text-file.html

>>> On Thursday, June 12, 2008 10:57 PM Eric Isaacs wrote:

>>> Here is a useful article on the subject:
>>> http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

>>> Submitted via EggHeadCafe
>>> Creating Google Motion Charts from Excel data
>>> http://www.eggheadcafe.com/tutorials/aspnet/86599bca-edda-4204-af15-7a1cf901a071/creating-google-motion-charts-from-excel-data.aspx