EXCEL and Query

  • Thread starter Thread starter Christopher McGeorge
  • Start date Start date
C

Christopher McGeorge

Microsoft Query won't give me access to data in a
Microsoft Excel list.

After connecting to the data source (another EXCEL
spreadsheet) the error message 'No tables visible' is
displayed.

I have named the source spreadsheet as described in the on-
line help, but still no result.

Is there something else I need to switch-on?

Help please.
 
Have you tried giving a name to the table in the source
spreadsheet.

Eg. Data is in A1:F2500 - highlight that area and go
Insert / Name / Define.... call it MyData - that table
name should become visible when you do the query from the
other spreadsheet.

Hope this helps, Paddy
 
Back
Top