ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   running proc in excel (https://www.excelbanter.com/excel-discussion-misc-queries/211175-running-proc-excel.html)

just_real

running proc in excel
 
Hi

I would like help with the following problem and was hoping to find
some answers here.

I would like to generate a chart from a proc that I have on a
database. I've managed to connect excel to the database. I have also
created the said proc in the database.

Where I'm stuck at is this:
1. I cannot / don't know how to run the proc from within excel.
2. I don't know how to run the proc such that I can input the
parameters required by the proc; once again from within excel.

Your help would be much appreciated. Thanks in advance.

Shane Devenshire[_2_]

running proc in excel
 
Hi,

by Proc you mean a procedure, code? And in what database would this be
occuring? Microsoft SQL, Access, People Soft, BW, Oracle, SAP?

Cheers,
Shane Devenshire

"just_real" wrote:

Hi

I would like help with the following problem and was hoping to find
some answers here.

I would like to generate a chart from a proc that I have on a
database. I've managed to connect excel to the database. I have also
created the said proc in the database.

Where I'm stuck at is this:
1. I cannot / don't know how to run the proc from within excel.
2. I don't know how to run the proc such that I can input the
parameters required by the proc; once again from within excel.

Your help would be much appreciated. Thanks in advance.



All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com