Thanks to both. Frighteningly simple if you know how!

Howwever, I am still getting an error message :

"Syntax error in FROM clause."

I will keep trying, as it is likely to be something I have done wrong.




"Tom Ogilvy" wrote:

Select your data,
Do Insert=Name=Define

Enter Database under name and click Add.

then save your workbook and try it again.

--
Regards,
Tom Ogilvy

"alfredo" wrote in message
...
I imagine there are easier ways to work with this, but I want to use
"queries" on a set of data which is currently in an excel file.

However, when I try to do:

Data/Import External Data/NewDatabase Query/Excel Files ...
... on the excel file. I get the following error message from Microsoft
Query:

"This data source contains no visible tables"

What am I doing wrong? How do I set up the excel file so that it is
clearly
seen as a table?

[It all works well when I do something similar with a very similar an
Access
db file.]

Thanks in advance.