Running an Append Query in VBA

[ProNetGroup]

I was wondering if anyone knew some basic syntax for an append query to be run in VBA. (i.e. not just the SQL statement, that is easy b/c I can find that in the SQL window of a query) I need to know how to parse the SQL statement together to get it to run in VBA. I am trying to do a very simple task: to insert data into one table. I want to do this basically:

Private Sub cmd_Click

Dim strSQL as String

strSQL = "INSERT INTO table ...... (the SQL statement)"

DoCmd.RunSQL

End Sub

Any information would be helpful!!! Thanks!!!

 

[ProNetGroup]

Nevermind, I think I figured it out!