Appending a recordset to an existing table

Open an ADO recordset on the Access table, then loop through the recordset returned by your stored proc, use the AddNew method to add a record, assign the values then loop back to  Addnew.

Sorry to ask such a dumb question but how do I open an ADO Recordset on the access table?

I have a table called Missions, which is open and has it's entries. I have a Query which pulls down all the relevant data.

I would assume I want to be looking at the table Missions (bare in mind I am using Access 2007 which has an overhauled menu.)

Ah so it is actually done with coding now. Super, this is something I can get my head around instead of navigating through these damn access menus.

Is it just VB or can C# be used in these forms?

Regarding the code

      !Field1 = rsSQL!Field1
      '... add other field assignments

I assume I add all my field assignment here for the entire recordset? Also would this work with earlier versions of Access or is it 2007 specific?

VB only I'm afraid.
Yes, add all the fields you want to assignment
The DAO recordset manipulation should work at least back to Access 2.

Now finally one last question (fingers crossed)

I have the table open which I want to have the above DAO code. So where do I go from here? I clicked on the VIsual Basic button but it would appear this requires a form so I can do anything code wise.

Or doi I create a module?

I am just confused between the steps of hooking up the code with my table, how and when the code gets run etc.

The easiest way to get straight to the code project is to use the shortcut key combination alt+F11
Add a module to the code projext and drop the code in there. You don't need anything else open (<I have the table open >?) - it's all done in code.
But if you're asking this question I wonder whether you've got a recordset for your Stored Proc output yet?

I created a pass through query and did :

exec myStoredProcedure

which pumps out a recordset. So once I saw that I had a feeling there should be a way to get the information from there out into my table.

Looking at the code

Set rs = db.OpenRecordset("MyAccessTable", dbOpenTable)

I can go ahead and call my stored procedure directly, which would  populate the recordset?

I just noticed that Acces 2007 has an unmathced query wizard which I can use to return rows which do not match between my Passthrough Query and my Tablle.

Would I need a 3rd query to take the results of this query and insert them into the table, or is there a quick way to do this in the same query (ie insert result set into table x)