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

Kumar AU

10y1.2kSQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suvendu Shekhar Giri10y ago
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 :)
0
Munesh Sharma10y ago
once go through this link
https://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/
0
Kumar AU10y ago
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
0
Munesh Sharma10y ago
http://dotnet-munesh.blogspot.in/2016/05/export-data-from-sqlserver-database-to.html
0
alice yang10y ago
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
0