MS Access Stored procedure , result into table

[dh_ander]

I wrote a sql pass through query which executes a storede procedure on my SQL server
All the code I need is : execute dbo.msp_Fill_CEDS

Now I want to put the result into a table "hlptblTest" in my access database.

The result of my stored procedure is a table with 3 colums my table "hlptblTest" also has 3 colums.

What would be the syntax to put the result of my stored procedure straight into my table?

 

[SydneyGeek]

Hi David,

Try this:

1. Build a second pas-through query that retrieves the output table from the stored procedure
2. Use a Make-table or Append query to push this into your local table

When you want to update data, run 3 SQL statements in sequence:
The stored procedure
A Delete query to clean out the data in the Access table
The Update query to push in the new data.

Note: this will work only if you do NOT have a primary key field in your Access table. In circumstances where I am pulling data in from a SQL source and may be refreshing everything, I don't bother with a local primary key

Denis