Runtime error '3251': Operation is not supported for this type of object

[ragtopcaddy via AccessMonster.com]

I've finally beaten this passthrough query into submission, but when I try to
use it as the table argument in a TransferSpreadsheet procedure in VBA, I get
the subject error msg. Here's the query:

SELECT Full_Name, ISNULL(Op_Com,'"') OpCom, ISNULL(Sub_Op_Comm, '"') SubOpCom
FROM dbo.v_Storage_Qtree_App
WHERE created='3/9/2008' AND tier_type Like '%Tier 1%'

When I run it in Access, it delivers exactly what I'm looking for. Any
suggestions would be deeply appreciated.

Thanks,