Can I use a pass through to execute a stored procedure?
How can I retrieve a resultant set from that stored procedure and put it in a make table?

Thanks
Michael

I'm looking at a remote SQL Server database and the processing is extensive. I just want the resultant for
further "What if" analysis.

Michael

To execute a sp:
Create a pass thru with something like this

Exec p_yourStoredProc

To use a pass thru to creat make table:
Use the pass thru as the source for the the make table

Exec TQS_RepClaims 'Met', '11/1/2005', '11/30/2005'

I have the above in query Q1 - it has return row = yes.

When I use make table Q2 (Q1 as source) and try to execute, I get the window 'Select Data Source ODBC' Screen.

If I manually select DSN CL_DevClaims I get the make table I want.

Let the query know where to look for TQS_Repclaims?

I have tried [CL_Devclaims].[TQS_RepClaims] and [CL_Devclaims].dbo.[TQS_RepClaims]

with out success.

Thanks,

Are you wanting to make the table on the local mdb or on the SQL Server?

Is the connection string stored with the query?