stored procedure to import data from sql database into excel

Question

stored procedure to import data from sql database into excel

Krish-315985

SSC Veteran

Points: 293
More actions
May 9, 2006 at 8:22 am

#168036

Please give some inputs on how to write a stored procedure to import data from sql database into an excel.
Thanks

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ted Jackson Grasshopper Points: 13 More actions · Answer 1

I have done this many times by setting up a DTS package to call the stored procedure and then write the results to an excel file. The DTS wizard works great for this.

Krish-315985 SSC Veteran Points: 293 More actions · Answer 2

How to do it without a DTS package?

Please let me know.

Thanks

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 3

You could convert this script into a stored procedure:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=763

Andy