Export Excel File - 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

General SQL Server Forums

New to SQL Server Programming

Export Excel File

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-07-19 : 12:47:21

Dear All,
I have run this procedure
EXEC sp_makewebtask
@outputfile = 'E:\testing.xls',
@query = 'Select * from Database_name..SQLServerTable',
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

and getting "Command(s) completed successfully."

But there is no file in by the name of Testing.xls.

Please help

X002548
Not Just a Number

15586 Posts

Posted - 2010-07-19 : 12:55:00

where are you looking?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-07-19 : 13:03:53

in E:

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-07-19 : 13:06:11

I have tried in my test server and getting this error
Msg 15281, Level 16, State 1, Procedure xp_makewebtask, Line 1
SQL Server blocked access to procedure 'sys.xp_makewebtask' of component 'Web Assistant Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Web Assistant Procedures' by using sp_configure. For more information about enabling 'Web Assistant Procedures', see "Surface Area Configuration" in SQL Server Books Online.

X002548
Not Just a Number

15586 Posts

Posted - 2010-07-19 : 13:45:54

in E:

On What Box?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-07-19 : 13:48:51

Try:
sp_configure 'Web Assistant Procedures', 1
RECONFIGURE

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-07-20 : 03:22:49

quote:
Originally posted by sanjay5219

Dear All,
I have run this procedure
EXEC sp_makewebtask
@outputfile = 'E:\testing.xls',
@query = 'Select * from Database_name..SQLServerTable',
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

and getting "Command(s) completed successfully."

But there is no file in by the name of Testing.xls.

Please help

After execution the file will be available at server's directory

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources