Microsoft query does not recognize tables in Excel spreadsheet

[JGPatrick]

Using Excel 2007 12.0 SP 2 on Windows XP

I have created an Excel spreadsheet, C:\Temp\PracDbase.xlsx with two tables:

Table1:
X Y
1 1
2 2

Table2:
X Y
1 1
2 2

Both of these are on the same worksheet, sheet1. The first table occupies
the range A1:B3, the second occupies the range D1:E3.

Both of these ranges have been converted to tables via Home/Format As Table.
If I look up names under Formulas/Name Manager, both of these
table names are there and they refer to the correct range.

ie, I am certain that the tables Table1 and Table2 exist in
C:\Temp\PracDbase.xlsx
and that they contain data.

With C:\Temp\PracDbase.xlsx closed, I attempt to query Table1
from another workbook using Microsoft Query. From Data/From Other Sources I
select Microsoft Query. In the dialog box I select Excel Files and Use Query
Wizard and click OK.

Next I select the file C:\Temp\PracDbase.xlsx and click OK. I then get a
message box saying "This file contains no visible tables."

Does anybody know any reasons why I might be getting this error message?
And the fix? My ultimate goal is to create a small database with a few tables
in Excel spreadsheets which I can query from other workbooks as needed.

Thanks.

 

[CyberTaz]

You'll probably get a more prompt response if you post to one of the groups
for Excel on the Pc ‹ this is the Mac Excel group. Start here:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac