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 : 1699 | Status : [Member] | Replies : 2

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

Thanks&Regards,
mahendrabasutkar

Reply | Reply with Attachment

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

0	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

0	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

Latest Posts