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

  • Thread starter ragtopcaddy via
  • Start date

ragtopcaddy via

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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question