how to Extract SQL Query result to Excel sheet in SQL server

Question

H,

how to Extract SQL Query result to Excel sheet in SQL server,

query runns every day its scheduled, 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 - Select * from temp --> result should go to Excelsheet