Question: how to export table data to excel in sql server 2008?
Answer: Click on new query and write a query to get table data.
Then right click on top of left corner and copy data with header or without header depends on requirements.
Open new excel file and paste copy data to that file.