Then you might want to use ADO instead.

http://www.erlandsendata.no/english/vba/adodao/
Mr Erlandsen's site has some good sample code on using ADO to interface with
Access - although you might be going to a different database engine, this
should give you the basics.

--
Regards,
Tom Ogilvy


wrote in message
...
Regarding the previous post. I am also interested in the
data, and not the query itself. Not really interested in
adding a QueryTable to the the sheet.

Thanks,
Howie