Querying Excel tables from Microsoft Query

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.
 
J

JGPatrick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top