Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query Wizard - Choose Columns
I hope that this is the correct list for questions on MS Query, and Query
Wizard in particular. From Excel Import External Data and connecting successfully using an ODBC driver to my DSN, I work through Query Wizard until I get to the Choose Columns page. The windows named 'Available tables and columns is correctly populated, and I am able to select to populate the window named 'Columns in your query'. But with a line in the latter window selected, the window named 'Preview of data in selected column' is not populated. How can I get this window to populate? Thanks. Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query Wizard - Choose Columns
Hi,
Click the + beside the table and select a field, then the Preview Now button will be active. Click it. If this helps, please click Yes. -- Thanks, Shane Devenshire "MichaelRobert" wrote: I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully using an ODBC driver to my DSN, I work through Query Wizard until I get to the Choose Columns page. The windows named 'Available tables and columns is correctly populated, and I am able to select to populate the window named 'Columns in your query'. But with a line in the latter window selected, the window named 'Preview of data in selected column' is not populated. How can I get this window to populate? Thanks. Mike |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query Wizard - Choose Columns
Shane:
Thanks. Stupid of me not to notice :-) Mike "ShaneDevenshire" wrote: Hi, Click the + beside the table and select a field, then the Preview Now button will be active. Click it. If this helps, please click Yes. -- Thanks, Shane Devenshire "MichaelRobert" wrote: I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully using an ODBC driver to my DSN, I work through Query Wizard until I get to the Choose Columns page. The windows named 'Available tables and columns is correctly populated, and I am able to select to populate the window named 'Columns in your query'. But with a line in the latter window selected, the window named 'Preview of data in selected column' is not populated. How can I get this window to populate? Thanks. Mike |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query Wizard - Choose Columns
Sorry guys. That didn't work, although the Preview Pane button did turn black
from gray. I am still not seeing any information in the Preview Pane. Could that be something to do with the database that I am looking at (although I know that I am selecting populated fields); or is it a Query Wizard setting? Mike "MichaelRobert" wrote: Shane: Thanks. Stupid of me not to notice :-) Mike "ShaneDevenshire" wrote: Hi, Click the + beside the table and select a field, then the Preview Now button will be active. Click it. If this helps, please click Yes. -- Thanks, Shane Devenshire "MichaelRobert" wrote: I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully using an ODBC driver to my DSN, I work through Query Wizard until I get to the Choose Columns page. The windows named 'Available tables and columns is correctly populated, and I am able to select to populate the window named 'Columns in your query'. But with a line in the latter window selected, the window named 'Preview of data in selected column' is not populated. How can I get this window to populate? Thanks. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Data Query Wizard | New Users to Excel | |||
Query Wizard Cannot Be Used To Edit This Query | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Question about Query Wizard | Excel Discussion (Misc queries) | |||
The Query Wizard window should be resizable. | Excel Discussion (Misc queries) |