Adam,
EXEC usp_Proc1
You will need to set up the ODBC connection string. The returned data will be read-only but can be used as a record source for a form or report.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 25 Apr 2016 15:40:09 -0700
Subject: [MS_AccessPros] Opening SQL stored procedure in datasheet view
How do I open a SQL stored procedure (SP) - e.g., named "usp_Proc1" - in Access datasheet view? This seems like a basic question, but I haven't been able to find a simple answer on the internet. The SP is a SELECT query. If needed, assume I have a connection string stConn.
The follow up need is how then to use that (and other) SPs as the recordsource for forms and reports.
Thanks
Adam
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 25 Apr 2016 15:40:09 -0700
Subject: [MS_AccessPros] Opening SQL stored procedure in datasheet view
How do I open a SQL stored procedure (SP) - e.g., named "usp_Proc1" - in Access datasheet view? This seems like a basic question, but I haven't been able to find a simple answer on the internet. The SP is a SELECT query. If needed, assume I have a connection string stConn.
The follow up need is how then to use that (and other) SPs as the recordsource for forms and reports.
Thanks
Adam
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!
.
__,_._,___
Tidak ada komentar:
Posting Komentar