Query Wizard - Choose Columns

M

MichaelRobert

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
 
S

ShaneDevenshire

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

MichaelRobert

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0
ODBC import with Excel 2007 with Query Wizard 3
is it possible ot use two or more columns as criteria in VLOOKUP? 3
Refresh columns not in query 1
Can't create a report from my query in Access 1
changing query source 2
Average values in only last 6 columns 8

Top