I notice no one has reponded to your request. So, here's my attempt to help.

Have you tried using MS Access unstead of MS Query. MS Access in far more
superior than MS Query. I'm running 2007 & use it all the time.

If you've never used Access, LINK to your SQL tables though an ODBC
connection. Create (or copy/paste) your queries in Access, then import your
data into Excel using the From Access connection wizard. The same way your
importing the data now with MS Query.

If you haven't already, try using the SQL server wizard (From Other Sources
in 2007)? My not sure how it works, I don't have direct access to the SQL
server.
--
Thanks, Kevin


"mr tom" wrote:

Hi,

I'm bound to Excel for purposes of making my output usable by normal human
beings and I generally use MS Query to query our data warehouse (SQL Server).

The thing is that Microsoft has totally neglected MS Query for well over a
decade. It is primitive, inflexible and just doesn't do the job.

Presuming that nobody has heard MS saying that they're going to either dust
it off or replace it, so failing that has anybody found a better alternative
as an excel add in?

Happy Christmas all.

Tom.