1

I'm executing my StoredProcedure like this:

    Dim qdef As DAO.QueryDef
    Set qdef = CurrentDb.CreateQueryDef("")
    qdef.Connect = CurrentDb.TableDefs("tblE").Connect
    qdef.sql = "EXEC StoredProc @Param1 = " & Me.Param1
    qdef.Execute

Now what I'd like to do with the results (since this wouldn't work)..- Is to Insert them into table: TempTable.

Structure of TempTable matches with the return values of the stored procedure.

How could I do something like: 'INSERT INTO TempTable (EXEC StoredProc)' with a LOCAL table?

CallumDA
  • 12,025
  • 6
  • 30
  • 52
Paramone
  • 2,634
  • 4
  • 31
  • 58

1 Answers1

0

you could write it in a tmp table in sql, open this table with a recordset and insert the values of the "SQL" tmp_table into your local temp table.

Maybe have a look here: How to insert ADO Recordset into MS Access Table

I hope i understanded your question correctly...

Community
  • 1
  • 1
Jul Pod
  • 370
  • 3
  • 16