MS Query Not Returning Data to Excel
 

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?

MS Query Not Returning Data to Excel
 

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

"lucycard" wrote:

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?