Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MLavey
Starting Member
2 Posts |
 Posted - 2011-08-18 : 16:51:52
|
| What is the best way to return results from stored procedure to MS Access? I execute my stored proc from an Access report. My stored proc runs successfully and returns one or more records, which I am storing in a temp table in the stored procedure. How do I get those results back to MS Access so I can place them on my report? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-08-18 : 17:06:31
|
Do a final SELECT * FROM the temp table as last query in procedure.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
MLavey
Starting Member
2 Posts |
Posted - 2011-08-18 : 17:58:52
|
| Thanks, I did that.But, how do I access those results from ACCESS? |
|
|
|
|
|
|
return results from stored proc to MS Access