MS QUERY w/out querytable

[Guest]

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

 

[Tom Ogilvy]

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.