Compare a value under a field to values in an array in WHERE clause

Hi experts,

I'm writing a procedure using VBA in Access. What I want is to select the records from a table with such condition that the values in a specified field do not equal to any of the values in an array which I DO NOT know the size.

myArray = "123, 456, 789"      <------------------ In this case there are 3 values in this array, but in my case I  WOULD NOT know how many values are in.

The pseudo code is:

strSQL = "SELECT myTable.* FROM myTable WHERE [aField] <> any one of the values in myArray"

Can anyone help me how to write the correct SQL syntax?
Start Free Trial