sql with loop and var

[amanda6192]

Hi,

I wish to loop around an array putting the values into a mysql table.

For y = LBound(arrquery) To UBound(arrquery)
   
    With rdoQry
    .SQL = "INSERT INTO `Query` ( `Query_ID` , `Query_text` , `Answered` )VALUES ('', 'arrquery(y)', '0')"
    Set .ActiveConnection = cnMySql
    .Execute
    End With
 
    cnMySql.Close
Next y

arrquery() is my array, but it doesnt like me putting it in the SQL like that, what do i need to put round the arrquery(y) to make sure that it knows thar it is a variable i am posting to it, not a string.

Thanks in advance for any help