Export Result Set to Excel - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

Export Result Set to Excel

Author

Topic

ranganath
Posting Yak Master

209 Posts

Posted - 2007-10-04 : 02:05:39

hi,

How To Export Result Set of Executed Stored procedure to Excel

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-04 : 02:08:07

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

E 12°55'05.25"
N 56°04'39.16"

ranganath
Posting Yak Master

209 Posts

Posted - 2007-10-04 : 02:29:41

Hi peso

Iam Asking From Stored procedure Not From Table

Exec usp_BillType_Get @CultureCode = 2
The Result set of above executed sp in Excel Format

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-04 : 02:32:04

Yes. What is your concern?

INSERT	OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\\computer\d$\testing.xls;','SELECT * FROM [SheetName$]')
EXEC	usp_BillType_Get @CultureCode = 2

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources