Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Redirect output of a SQL query to an excel file using SP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-17 : 07:23:46
kiran writes "Hi,

I'm trying to write a Stored procedure which would execute a SQL query (say, Select * from orders). My requirement is to push the resultset into an excel file.

Thanks in Advance"

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-05-18 : 03:53:02
Can you not just call it from within Excel?

steve

A sarcasm detector, what a great idea.
Go to Top of Page
   

- Advertisement -