vba array type missmatch

[Jollyfrog]

Hi,

im trying to extract values from an array that i have filled with an sql statement, only problem is i get a type missmatch error?
it could be that the array is very large! maybe 400 entries

rst.Open "Select ([Channel Brand]) as pc from ChannelBrand WHERE [Channel Brand] IN ('" & Join(Application.Transpose(idtsd), "','") & "')", conn

idtsd is defined as a variant

thanks