| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute stored procedure
Can I exceute a stored procedure from Excel?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute stored procedure
Yes, using ADO.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark Goldin" wrote in message ... Can I exceute a stored procedure from Excel? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute stored procedure
Do you mean a database 'stored procedure'? Yes, with ADO (ActiveX Data
Objects) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Mark Goldin" wrote in message ... Can I exceute a stored procedure from Excel? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
execute stored procedure
.... or MS Query
e.g. (SQL Server): CREATE PROCEDURE MyStoredProc (@start_date DATETIME, @end_date DATETIME) AS SELECT RefID, DateEffective, Earnings FROM EarningsHistory WHERE DateEffective BETWEEN @start_date AND @end_date Then this in the SQL window: EXEC MyStoredProc '01 JAN 2002', '01 JAN 2003' -- "Mark Goldin" wrote in message ... Can I exceute a stored procedure from Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data return from SQL Stored procedure... | Excel Discussion (Misc queries) | |||
| execute stored procedure from excel | Excel Worksheet Functions | |||
| Execute procedure on startup | Excel Programming | |||
| Run a stored procedure in Excel 2K | Excel Programming | |||
| Execute stored procedure using DAO | Excel Programming | |||
Hybrid Mode
