What is a "visible table" with MS Query?

[Glory]

I keep getting problems with ADO where I can't se any tables in my workbook... which has a row of headers and distinct columns of data.

Sometimes I can get MS Query to recognize the tables by making the header rows bold. Sometimes that doesn't work.

Is there a way to force MS Query or any SQL routine to treat the source range as a table, no matter what it finds there?

EG:

szSQL = "SELECT * FROM [" & "Errors$" & "A1:J2" & "];"

The code claims not to find the table, even though I'm specifically telling it to grab this range of data.

Any ideas?

 

[Glory]

Sometimes I can use this MSDN bug report method to get "System Tables" to appear, and that solves the problem. But only sometimes.

This is a serious issue that I can't seem to permanently resolve.