In Access I generated the following query:
SELECT dbo_tblProj.strProj, dbo_tblWood.strSample,
dbo_tblWoodCell.dtsFinish, "C" AS Scnr
FROM (dbo_tblProj INNER JOIN dbo_tblWood ON dbo_tblProj.lngIdProj =
dbo_tblWood.lngIdProj)
INNER JOIN dbo_tblWoodCell ON dbo_tblWood.lngIdWood =
dbo_tblWoodCell.lngIdWood
WHERE (dbo_tblWoodCell.dtsFinish Is Not Null);

Which renders a list of the following type:
strProj strSample dtsFinish Scnr
ProjA Sample1 2004-06-18 C ... Etc

Pasting the same Query into the Excel Query Wizard and executing it, first
gives a message about not being able to display the query graphically, and
then the message "Could not add the table 'dbo_tblProj'."
I tried to explicity name the DB by "...FROM (Database.dbo_tblProj..." but
that gave the same result.
(The query: SELECT tblProj.strProj FROM SS3Data.dbo.tblProj tblProj works
just as expected when entered into Excel).

Q1: Shouldn't any query generated in Access also work from Excel?
Q2: How can I make this specific query work in Excel (it is eventually
targeted for a Pivot graph, including new Excel formulas in new columns)

Best regards /Ake