How to transfer data from table to Excel file using sqlserver 2003

Posted by Mahendrabasutkar under Sql Server on 8/9/2011 | Points: 10 | Views : 1077 | Status : [Member] | Replies : 2
How to transfer data from table to Excel file using sqlserver 2003


Thanks&Regards,
mahendrabasutkar




Responses

Posted by: Mcadeepuraj on: 8/9/2011 [Member] Starter | Points: 25

Up
0
Down
use DTS package

Deepak Kumar

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kunalverma31 on: 8/16/2011 [Member] Starter | Points: 25

Up
0
Down
you directly copy data into excel. .i.e

1) Select * from Table1
2) Right click on Results panel and select Copy with header option(SQL 2008)
3) Paste the same in excel file


Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response