Put resutls of StoredProc using Passthrough query into an Access T

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillyRogers - 20 Jul 2007 21:40 GMT

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

Signature

Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

Reply to this Message

Douglas J. Steele - 20 Jul 2007 23:32 GMT

Create a MakeTable query based on qryPassThru

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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
[quoted text clipped - 18 lines]
>
> End Sub

Reply to this Message