Ake

I do not have anything to test this myself but here are some tips:

not all Access queries work, queries using (access) VBA in their
definition wont work in Excel.
Look at http://homepages.paradise.net.nz/~ro...eryeditor.html
for a better editor
Start with a simple query in the visual grid, and after that start
changing it, msquery is very picky on syntax and format.
For complex queries create views/queries or stored procedures on the
database for added power and ease. Excel can sometimes reject complex
but valid queries.
Excel ODBC uses double quotes as identiefier delimiter, but can also
use the datasource native identifier delimiter (usually square
brackets)


DM Unseen