How to export data into .csv file thru query

Hi
http://dimantdatabasesolutions.blogspot.com/2007/09/insert-data-into-t...-file.h


<Narasimha Rao> wrote in message ...
> 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
 >> Stay informed about: How to export data into .csv file thru query 

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:16 AM Narasimha Rao wrote:

> 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


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

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


>>> 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-fi...-using-


>>> Submitted via EggHeadCafe
>>> Creating Google Motion Charts from Excel data
>>> http://www.eggheadcafe.com/tutorials/aspnet/86599bca-edda-4204-af15-7a...901a071
 >> Stay informed about: How to export data into .csv file thru query