How to Extract the Query result to directly to .XLSX File

Question

Dear All,

Could you please let me know how to Extract Query result to Excel sheet in SQL server,

My query is batch Job, so I need to keep all my query result in Excel sheet, Later I will do FTP.

Please suggest me is there any way to do in SQL Server.

Note :- Not using Result to File in Management studio, I need to know using any scripts in Sql

Example this is my Query :- Select * form Users where Createddate >= dateadd(day,datediff(day,1,GETDATE()),0).

This result should directly go to Excel sheet

Please help me

Suvendu Shekhar Giri · Answer

Hi, Here is a complete article for the solution to your problem using SSIS Package. http://www.codeproject.com/Articles/402958/SSIS-Package-Export-Data-from-Database-Daily-to-Ne Hope, it helps :)

Munesh Sharma · Answer

once go through this link https://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/

Kumar AU · Answer

Hi Mahesh and Alice, Thanks for your response, I don't need a code through C#/.Net programming. I need to do this task using SQL Script only, Could you please help me

Munesh Sharma · Answer

http://dotnet-munesh.blogspot.in/2016/05/export-data-from-sqlserver-database-to.html

alice yang · Answer

Hi, Refer to the following links: http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/ http://csharp.net-informations.com/excel/csharp-excel-export.htm

How to Extract the Query result to directly to .XLSX File

Answers (5)