execute multiple mySQL statements at once

[austin350s10]

I am working on some code that needs to add data into a database. I have no problems adding data when I am trying to execute one SQL statement at a time. My problem comes in when I attempt to execute 2 or more SQL statements at once. I know my syntax is correct, as I am able copy the value of the mySQL variable and execute it directly in my database without problems. Is there a way to run multiple SQL statements without looping through and executing each statement? Any ideas would be appreciated...

my code snippet:

'ContactSQL and RefSQL both contain an INSERT statement
mySQL = ContactSQL & RefSQL
Sql.Execute mySQL