Capturing SQL return.....

I'm attempting to automate an MI reporting task, rather than building queries, etc, in Access I'm trying to access the DB directly from Excel using the following VBA:

Please Login or Register  to view this content.

So....silly question but I've no clue how to assign the resulting output to a variable or even spit the output to a new worksheet.....

Please Login or Register  to view this content.

is one way to do it