Querying Excel tables from Microsoft Query

  • Thread starter Thread starter JGPatrick
  • Start date Start date
J

JGPatrick

Apologies if this posts twice. Since my posting hasn't shown up in 5 hours,
I'm assuming it got lost.

I cannot query a Microsoft Excel workbook with Microsoft Query.
The error message I get is "the data source contains no visible tables".
But the workbook that I am trying to query contains two named tables.

Any suggestions on what the problem might be?

Thanks.
 
For posterity, here is the fix.

If you have a range that has been converted to a table and given a table name,
as opposed to simply a named range, Microsoft Query will not recognize it as
a database table. I guess that would make too much sense.

What you have to do is convert the table to a range (Table Tools/convert to
range),
then give the range a name. Then MS query will recognize it as a table when
you select the workbook as the data source.

Go figure.
 
Back
Top