MS Query in excel
 

trying to run MS query from a excel spreadsheet. Error of 'no visible
tables'. Checked no hidden rows or columns. please help, driving me crazy

You can either name the range that you want to query (Select the range, then
go to the name box, the white box to the left of the formula bar, type a
name and press Enter), or, check the 'System Tables' box that appears in the
'Table Options' dialog.

--
Regards,

Juan Pablo González
Excel MVP

"kit" wrote in message
...
trying to run MS query from a excel spreadsheet. Error of 'no visible
tables'. Checked no hidden rows or columns. please help, driving me
crazy

thank you, works brilliantly, your a star

"Juan Pablo González" wrote:

You can either name the range that you want to query (Select the range, then
go to the name box, the white box to the left of the formula bar, type a
name and press Enter), or, check the 'System Tables' box that appears in the
'Table Options' dialog.

--
Regards,

Juan Pablo González
Excel MVP

"kit" wrote in message
...
trying to run MS query from a excel spreadsheet. Error of 'no visible
tables'. Checked no hidden rows or columns. please help, driving me
crazy

can I ask another Q. Iwant the query to pull records where the date is less
than today, what query operator should I use

"Juan Pablo González" wrote:

You can either name the range that you want to query (Select the range, then
go to the name box, the white box to the left of the formula bar, type a
name and press Enter), or, check the 'System Tables' box that appears in the
'Table Options' dialog.

--
Regards,

Juan Pablo González
Excel MVP

"kit" wrote in message
...
trying to run MS query from a excel spreadsheet. Error of 'no visible
tables'. Checked no hidden rows or columns. please help, driving me
crazy