run-time error '13' type mismatch

Originally Posted by JosephP

the elements of the array can only have 255 characters. you don't need the array at all-just build the sql string up as one string and pass that.

thanks joseph.could u expand on your answer a little? when u say i dont need the array, what should i use instead? sorry for my ignorance!