MS Query in excel

K

kit

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
 
J

Juan Pablo González

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

kit

thank you, works brilliantly, your a star

Juan Pablo González said:
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
Click to expand...
 
K

kit

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