Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to insert data in Excel from a *Stored Procedure* using
OLE-DB? I use something like: INSERT INTO [Sheet12$] SELECT * FROM [odbc;Driver={SQL Server};Server=blabla;Database=Northwind;User ID=bla;Password=bla].Orders I'd like to use something like: INSERT INTO [Sheet12$] EXECUTE [odbc;Driver={SQL Server};Server=blabla;Database=Northwind;User ID=bla;Password=bla].GetOrdersProc() Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can Oracle DB Stored procedure be called in MS Excel? | Excel Discussion (Misc queries) | |||
execute stored procedure from excel | Excel Worksheet Functions | |||
Getting stored procedure result to excel | Excel Programming | |||
Run a stored procedure in Excel 2K | Excel Programming | |||
Passing parameter from Excel to stored procedure? | Excel Programming |