Qundi :

sqlString = "SELECT * from Prodotti where idprod="&myArray(0)&""
for iLoop= (lBound(myArray)+1) to UBound(myArray)
if myArray(iLoop) <> "" then
sqlString= sqlString& "UNION SELECT idprod="&myArray(iLoop)&""
end if
next


Diventa cosi; cmq ora lo provo.grazie