You can always call a stored procedure from Excel. Typically I will
register an ADODB class. Then I can use the ADODB.Connection.Recordset
object to do what I want. Whether your sp uses a SELECT to set a value
or to return a results set you can get what you want through Excel. Of
course then you probably will need to use some VBA code to manipulate
the stuff from there.
Without knowing what you have in your sp, another alternative (possibly
simpler) is to create a view that you can call from MS Query and
automatically populate cells in Excel. I've never tried to call a sp
with MS Query. Perhaps someone else knows if this works.
-----Original Message-----
From: Aarons Simon
[mailto:mssqldba-ezmlmshield-x11838028.[Email address protected]
Sent: Tuesday, May 31, 2005 4:26 AM
To: LazyDBA Discussion
Subject: RE: Excel and stored proc
You could call the sproc from within a DTS and output to excel.
-----Original Message-----
From: Ananda Kumar
[mailto:mssqldba-ezmlmshield-x63048995.[Email address protected]
Sent: 30 May 2005 14:24
To: LazyDBA Discussion
Subject: Excel and stored proc
Hi All,
i have got a store proc. is there any way through which i can
put the output in an excel file.
Or in excel can we run a sp and display the results.
Regards
Anand
-----Original Message-----
From: Benbart
[mailto:mssqldba-ezmlmshield-x41919670.[Email address protected]
Sent: Sunday, May 29, 2005 5:38 PM
To: LazyDBA Discussion
Subject: Hi all ... am just trying out the rules of my new email client
...
Am just trying out my new email client program if the rules are working
...
Please ignore and sorry for the inconvenience ...
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
########################################################################
#############
This message is for the named person's use only. It may contain
confidential,
proprietary or legally privileged information. No confidentiality or
privilege
is waived or lost by any mistransmission. If you receive this message
in error,
please immediately delete it and all copies of it from your system,
destroy any
hard copies of it and notify the sender. You must not, directly or
indirectly,
use, disclose, distribute, print, or copy any part of this message if
you are not
the intended recipient. TransWorks Information Services Ltd. and any of
its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where
the message states otherwise and the sender is authorized to state them
to be the
views of any such entity.
########################################################################
#############
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------------------------------------------------------
120 years of the MDU: Still the leading choice
-------------------------------------------------------------
MDU Services Limited (MDUSL) is authorised and regulated
by the Financial Services Authority in respect of insurance
mediation activities only. MDUSL is an agent for Zurich
Insurance Company and Converium Insurance (UK) Limited. In
Ireland, MDUSL is a tied agent of Eagle Star Insurance
Company (Ireland) Ltd and is regulated by the Irish Financial
Services Regulatory Authority. MDUSL is an agent for the
Medical Defence Union (the MDU). The MDU is not an
insurance company. The benefits of membership of the MDU
are all discretionary and are subject to the Memorandum and
Articles of Association.
MDU Services Limited Registered in England 03957086.
Registered Office: 230 Blackfriars Road London SE1 8PJ
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page