Exporting from sql server 2008 r2 to excel with header
I'am trying to export data from my database to excel . The problem is my code is running but once i check my excel file there's no header included but just only the data in every particular header.
here's my code .. please suggest or help me to solve my problem . thank you.