Put resutls of StoredProc using Passthrough query into an Access T

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top