Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query Excel database from desktop | Excel Discussion (Misc queries) | |||
Micosoft Query does not export result set to excel | Excel Worksheet Functions | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Using a SQL like query to query an excel sheet | Excel Worksheet Functions | |||
Excel Query Via Sybase | Excel Discussion (Misc queries) |