| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.programming
|
|||
|
|||
How to pass an Excel range as an argument to a SQL Server stored Procedure
"George Hutto" wrote in message ...
Can I do the reverse? INSERT INTO myexcel...namedrange SELECT x, y, z, FROM mytable? Sure can. Run this query against a MS Jet connection: INSERT INTO [Excel 8.0;database=C:\myexcel.xls;].[namedrange] SELECT x, y, z FROM [ODBC;Driver={SQL Server};SERVER=MYSERVER;DATABASE=MyDB;UID=;Pwd=;].mytable Note myexcel.xls should be closed to avoid the memory leak bug (Q319998). You can do something similar in SQL on the server side but I can't remember the exact syntax off the top of my head. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
| Importing Data from a Stored Procedure (SQL SErver) | Excel Programming | |||
| How can I grab data from a SQL Server stored procedure | Excel Programming | |||
| Passing parameter from Excel to stored procedure? | Excel Programming | |||
Threaded Mode
