Showing posts with label effective. Show all posts
Showing posts with label effective. Show all posts

Monday, March 12, 2012

Get the Sql server query result in Excel sheet.

Hi All,

My question is, when i run a query in sql server the result should go to an Excel sheet automatically.what would be the effective and easiest way.

Im using Sql server2000,MS office 2003.

hi,
you can create a package in DTS..

-clintz|||

This is the frequent question in this forum. Check the following posts to get your answer.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1688955&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1157801&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124641&SiteID=1