SQL Query loading in MS Query but not importing data to excel

About the only advice I can offer is to check the command string. There might be a difference between the query you think Excel is using and the query it is actually using. I've had MS-Query rewrite some of my queries, particularly where clauses.

Generally speaking, my queries are too complex to accept parameters, so I write the query and paste it to a column in an Excel table. Where I need a parameter like a date I put '&DATE' in the code. Then in column B I have a formula like =SUBSTITUTE(A4,"&DATE",Report_Date) where Report_Date is a named range on the spreadsheet, very often the string representation of a calculated date.

There is a short bit of VB code that takes the translated SQL (in column B) and places it directly into the command string bypassing at least a part of MS-Query. You might want to try that. This article has a brief explanation and code at the end of it: http://www.utteraccess.com/wiki/index.php/MS_Query