R
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,
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,