Exporting data from SQL Server to Excel

Question

i;m trying to automate the exporting of data from an sql server table to an excel using this script

EXEC sp_makewebtask 
    @outputfile = 'C:\testing.xls', 
    @query = 'Select * from HCIndonesia_20Jul2010..Combine_Final', 
    @colheaders =1, 
    @FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

but i;m getting an 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.

Justin · Accepted Answer · 2010-07-22 07:29:43Z

2

This blog article might help you.

It sounds like you simply need to do:

sp_configure 'Web Assistant Procedures', 1
RECONFIGURE

And your script should work (as long as you have permissions on the SQL server)

answered Jul 22, 2010 at 7:29

Justin

87.2k49 gold badges231 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

marilyn Over a year ago

hmm. now i another problem: Msg 17750, Level 16, State 0, Procedure xp_makewebtask, Line 1 Could not load the DLL xpweb90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). is there a .dll i'll have to get?

Justin Over a year ago

@marilyn - It looks like this error is due to attempting to run this SP on SQL Express - this stored procedure is (according to Google) deprecated, and so you should probably look into an alternative way of doing this.

Collectives™ on Stack Overflow

Exporting data from SQL Server to Excel

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related