How to transfer data from SQL Server to Excel [closed]

Question

The orders table is the sales invoice information.

Transferring this information from SQL Server to Excel is possible with a query.

There is a data transfer wizard method to transfer in the

data, but I have to do it with C# code or T-SQL query.

Answer 1

Why do you have to make it with T-SQL or C#?

You can make with SSIS package and call that from C# or T-SQL.

If that is possible, I suggest trying it.