MS Query Not Returning Data to Excel

[Guest]

I have no desire to do this in VBA. I am using SQL in MSQUERY to retrieve
data from SQL SERVER. It comes in fine, but when I tell it to return data to
Excel, all it does is place the name of the query in the upper left hand
corner of the spreadsheet, whether a new sheet or existing one is selected.

How do I get a simple display of the results of the query into the
spreadsheet?

 

[Guest]

you need to use the pivot table function to see your data in excel.