View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alfredo Alfredo is offline
external usenet poster
 
Posts: 17
Default Problems using MS Query to access an Excel file

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.