Question: how to export table data in sql server 2008 to excel?
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.