Steven,
You can certainly query DBs from Excel. Check out DataGet External DataNew
Database Query.
Whether Excel/MsQuery/<Your DB driver can handle that monster is another
question.

Why not create a stored procedure or query in your DB, then ADO you can set
the parameters and create a recordset etc.

As for SQL, could you not simplify with something like:
..... WHERE (Multi_J_Data.[Worked State]) NOT IN (SELECT {However your decide
not these])
....etc

But it depends somewhat on what you are currently doing to get the data into
Excel.

NickHK

"Steven" wrote in message
ups.com...
Hi,

I currently have an excel based application that will extract a whole
load of data from our Databeses which I'm then having to filter
additonally by going back into SQL.

Is there anyway I can incoporate this SQL query into the excel app?

Many thanks in advance.

SELECT Multi_J_Data.[Period Start]
, Multi_J_Data.[Period End]
, Multi_J_Data.SURNAME
, Multi_J_Data.[FIRST NAME]
, Multi_J_Data.[Withholding State]
, Multi_J_Data.[Resident State]
------------ CUT ---------