| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to call a SQL Server Stored Procedure from within Excel
I am totally new to Excel programming, so please be patient with me while I
try and explain what it is that I need. I would like to call a SQL Server stored procedure from Excel and have the results placed in a specific range of cells, for example starting at D7 to K7 for however many rows are returned. So my question is this: What is the best way to call the SQL Server Stored Procedure and how do i place the results in a specific range of cells? Should I place a button on the page and call the proc on the click event? Any advise is greatly appreciated. -- Thanks, Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to execute a stored procedure in SQL server from Excel 2007? | Excel Programming | |||
| Call a procedure whose name is stored in a variable | Excel Programming | |||
| Run SQL Server stored procedure in Excel macro | Excel Programming | |||
| How to pass an Excel range as an argument to a SQL Server stored Procedure | Excel Programming | |||
| calling a stored procedure on MS SQL Server within MS Excel 2000 | Excel Programming | |||
Threaded Mode
