473,395 Members | 1,457 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

How to create an EXCEL file in advance and want to export data to it in sql2008?

147 100+
Hi,

This is the query, i am using to export the data to excel(without creating excel in advance in the local drive)

Expand|Select|Wrap|Line Numbers
  1. EXEC sp_makewebtask 
  2. @outputfile = 'C:\testing.xls', 
  3. @query = 'select * from dbname.schemaname.tbname', 
  4. @colheaders =1, 
  5. @FixedFont=0,@lastupdated=0,@resultstitle='Testing'



Error:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_makewebtask'.


How to solve this error? Thanks in advance
Mar 9 '11 #1
1 3715
Rabbit
12,516 Expert Mod 8TB
That stored procedure with that name doesn't exist. Or the account running it doesn't have the permission to see it. Or you're running it from the wrong database.
Mar 9 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Cathy | last post by:
Hi All, Can anyone tell me how to create an Excel (.xls) file from a VB.Net app? I have a SQL Server database that contains a table with the data I want to export. How do I create the file? Any...
6
by: Paul | last post by:
I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...
2
by: otto | last post by:
Hi, all: I want to create a pdf file with data retrieved from a SQL Server database. How can I do this? Is there any Acrobat Reader api for doing this? Can I export data in an Excel workbook to...
2
by: noopathan | last post by:
Hi experts , I have an excel file in the below format --------------------------------------------------------------------- CodeID CodeName Market Name Date...
8
by: LimaCharlie | last post by:
Hi, Question pls. I have an MS SQL local package where it exports data from SQL table to Excel file. My question is, how can I erase all the records in my excel file before i export the new data...
4
by: Rahul | last post by:
I want to create an excel file for report in asp.net 2.0 ... without having office installed on the server. Rahul
0
by: Paul | last post by:
Hello, I have a VB 6 app that creates Excel files to export data that works fine. When I ported it to VB.NET it creates the file, but seems to finish writing the data and releasing the file...
0
by: JFKJr | last post by:
Hello everyone! I am trying to export Access table data into Excel file in such a way that the table field names should be in the first line of each column in excel file followed by field data, and...
7
by: rameshvummadi | last post by:
I want to create an excel file (Microsoft Excel) with tabs using perl. I need to run my perl script in the Unix environment. I can do it with Spreadsheet::WriteExcel. Can I create the excel file...
2
by: phanimadhav | last post by:
Hello Experts, I developed following code for excel file creation by using Dataset.But i got the following error(NullRefernec Exception was caught) at the response.End() My...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.