How can I export my reports to tab delimited csv file?

Hi,

I am trying to export the sql script data to pipe delimited text file.

I did below steps

1. JOined the sql tables and wrote the sql script.
2. export the results to glbal temp table.
3. then BCP the results to pipe delimited text file.

here is the select query

Select dbo.FN_Decrypt(@master, Login.LoginSkey,PatientDisplayID) as 'Client ID', ISNULL(SugarEntryCount,0) as 'BG Count',
    ISNULL(CarbsEntryCount,0) as 'Carb Count', ISNULL(MedsEntryCount,0) as 'Med Count'
   
    INTO ##PIPE_REPORT
FROM #temp_patients inner join Login ON  Login.LoginID = #temp_patients.PatientID

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM ##PIPE_REPORT " queryout C:\Data\Objects.txt -t"|" -c -T '

DROP TABLE #temp_patients

I have successfully exported data into pipe delimited text file. but only data not the columns names

I need columns names inthe first row, please let me know how can i do this?

and also I need special characters enclosed in quotes. And how can I describe each column data type in text file? I will be having alphabets and numerics in text file.

Thank you

This is my MYSQL  database connection :-

public static OdbcConnection Connection = new OdbcConnection("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=jdmcrm; User=root;Password=admin;");

My table name is "customer" and  fields liek customerId , companyName , address and date ;

How to do wide search and export the records to excel file ? im quite new in asp.net .

Pls advise . Thanks

Hi all

I have the following configuration MOSS 2007 + SSRS 2005 running in moss integrated mode.

I have a bunch of reports in the MOSS 2007 document library and I'm looking for a way to do the following:

From a custom web part, when user clicks some button pass parameters selected by user on a web part to a report and export report to a fileshare.

I've tried to cope with subscriptions but I can't find how I can override reports parameters. It seems to me that I have to deal with SSRS service model directly since I wasn't able to find any other API.

So the question is how to do that with SSRS web services from MOSS web part programmatically? Maybe there is another way?

I just want to know except use owc

can we use SQL Server to export excel file ?

if it can be , how to do? thanks alot