export table data into excel using sql server 2000. [Resolved]

Posted by Mahendrabasutkar under Sql Server on 6/27/2011 | Points: 10 | Views : 3484 | Status : [Member] | Replies : 3
Hi All,
Please provide me the following code
Query to export table data into excel using sql server 2000.


Thanks&Ragards
mahendrabasutkar




Responses

Posted by: Lakn2 on: 6/28/2011 [Member] Starter | Points: 50

Up
0
Down

Resolved
try this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Thanks&Regards
LakshmiNarayana Nalluri.

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

Posted by: Sriramnandha on: 5/20/2012 [Member] Starter | Points: 25

Up
0
Down
HI,

EXPORT DATA EXCEL TO SQL SERVER U CAN USE DTS(DATA TRANSFERMATIONN SERICES) OPTION AVILABLE IN SQL SERVER 2000

REGADS

sriram

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

Posted by: Ajay.Kalol on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
Just Copy and Paste data of that Table to excel,

so Simple

Ajay
ajaypatelfromsanthal.blogspot.in

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

Login to post response