View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DevInstinct DevInstinct is offline
external usenet poster
 
Posts: 6
Default OLEDB - INSERT INTO Excel FROM Stored Procedure

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