|
|
#1
03-13-2014, 10:33 AM
|
|||
|
|||
Word 2010 VBA - Run a stored procedure that returns 1 row of data
Word VBA newbie...
I need to run an existing MS SQL stored procedure with 2 parameters and it will return a row of data. I've seen examples on how to call the stored procedure, but do not know how to read the data it sends back. vba 
|
|
#2
03-13-2014, 09:30 PM
|
||||
|
||||
|
It's not something I've used, but this code http://www.ozgrid.com/forum/showthread.php?t=78325 shows how to obtain the query results. In particular, see the 'myReturn = rst.Fields("myVariable").value' line near the end.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
#3
03-14-2014, 07:00 AM
|
|||
|
|||
|
Thank you...
Thank you for the link. Just what I needed.
|
|
| Tags |
| ado recordset |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to release hard returns?
|
markg2 | Word | 13 | 05-08-2023 01:38 PM |
|
Word 2010 cannot find data source
|
wsdb | Mail Merge | 7 | 09-05-2012 03:16 PM |
| Easy send/save Excel data to Database Table or Stored Procedure | TonyHarvard | Excel | 3 | 07-11-2012 12:43 PM |
| Word 2010 discard editing data not working | Ravenant211 | Word | 3 | 02-16-2012 07:25 PM |
| excel where is procedure being called from | davids67 | Excel Programming | 1 | 11-18-2011 06:48 AM |
Windows XP 
Office 2010 32bit
Linear Mode
