Access Queries not seen in Excel
 

Hi,
I have a queriy in Access that I want to import into Excel (2007).
I go to "Get External Data" - "From Access" and select the Access database.
Several tables and queries are shown but some are not (naturally the one I
want is not shown!)

I had the same problem importing the same query into Word and resolved it by
setting the "Confirm File Format Conversion on Open" option in the Advanced
Options. (Then choosing DDE when opening).

Is there a similar way I can get Excel to see this query?

Thanks
Richard