In SQL Server 2012, I have a stored procedure which returns rows from a data table. I am writing an application which uses Microsoft Access 2013 as a front end to this database. I want to copy the rows returned by the procedure into a local Access table which has the same columns and compatible data types as the SQL Server table.
Given a User ID, the routine returns the data rows the user is allowed to see. The rows can be obtained from a query like this:
EXEC [dbo].[PERMITTED_DATA_VALUES_FOR_USER_ID] @USER_ID = 1
Within a code module, say as the after click event handler for a button, how would I run this query and store the results in the Access table?