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

No comments:

Post a Comment