Need to create an excel file by using t-sql code

Question

I have to create dynamically named excel file using t-sql code. I tried many searching and trying but couldn't find the solution please help me. I am using sql server 2005.

Answer 1

You should do this in your frontend, not in your sql code.

But I found a tutorial here.

Tjeu