LinkBack URL
About LinkBacks
query wizard.JPG
this is how my query wizard looks
data->from other sources -> from Microsoft query -> Database name from ODBC
other query.png
here is another users when I follow the same process
why is the second one different?
query wizard.JPG
this is how my query wizard looks
data->from other sources -> from Microsoft query -> Database name from ODBC
other query.png
here is another users when I follow the same process
why is the second one different?
I followed the process that you loosely outlined and managed to get both screens. The second one that you get is likely over top of the one that you want. Try moving it to see if the column choosing dialogue is under it...it was in my test.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
thanks. I looked everywhere (minimized everything) and still nothing.
the first one is the only screen that comes up for me on my machine. the second one is on the other machine. I am going to try an update to office 365 and see what happens
I also found that if I selected something other than Excel and clicked on the icon in the task bar that the column selector became visible from wherever it was hiding (on other tests).
This is the exact procedure that I followed:
1. Click on From Other Sources
2. Click on From Microsoft Query
3. Click on Excel Files
4. Click OK
5. Click on List Files of Type and Select All
6. In the right hand pane navigate to the data file of your choice
7. In the left pane click on the file that you want.
8. You should now be at the dialogue to choose the columns to include in the query.
9. Select the columns and click the right arrow to put each column that you want in the right pane. When finished click next and follow the instructions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks