Put resutls of StoredProc using Passthrough query into an Access T

[BillyRogers]

I have this code that runs a (SQL Server) stored procedure using a
passthrough query. Is there a way to change this code so that it creates an
Access table with the results in it?


Private Sub btnAccessAssocDemoVol_Click()

Call AssocConcat

Dim qdfPassthrough As DAO.QueryDef
Dim rsCurr As DAO.Recordset
Dim strSQL As String


strSQL = "Exec [GetAssocDemographics&Volume&CB] @MonthYearList='" &
MyAssocDates & "', @OrderList='" & MyAssocNums & "'"



Set qdfPassthrough = CurrentDb().QueryDefs("qryPassThru")
qdfPassthrough.Sql = strSQL

DoCmd.OpenQuery "qryPassThru", acNormal, acEdit


End Sub
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

 

[Douglas J. Steele]

Create a MakeTable query based on qryPassThru