Change the script to export to excel

Question

Hi All ,

my request is quite straightforward , I have a script similar as below , it can output what I want to see on sql server , what I would like to do is schedule to script and output to a excel file , would advise how to change the script to make it work ? thanks

select * from user_table ;

Answer 1

Hi @chan patrick

There is no way to export from a SQL statement directly to CSV. You can either use the first option or other options available on the website seen below.

1) The easiest way to do this is to use the BCP Tool (via command line):

bcp user_table out C:\Users\user\Downloadsdata.csv  
-S SERVER\MSSQLSERVER,1433 -c -t"," -T  

2) Other options are available below:

https://learnsql.com/blog/how-to-export-csv-from-sql-query/

-----------------------------------------

If this is helpful please accept answer.

Answer 2

and output to a excel file

With plain T-SQL that's more then difficult, better use a ETL tool like SSIS = SQL Server Integration Services.
See Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS)

Answer 3

Hi @chan patrick ,

Welcome to Microsoft Q&A!
Please also refer to this blog: https://solutioncenter.apexsql.com/how-to-import-and-export-sql-server-data-to-an-excel-file/
This blog contains some screenshots which may help you get some ideas.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.