Software

Ask something
Discussion Locked

MS Query problem in XL97

0 helpful
3 replies

by mrmolio

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I use the Query Wizard in XL97, It gets to the step where I should be able to Choose Columns - I can see the Access database tables & queries, but when I click the "plus" sign next to each, I get no fields displaying. The plus turns to a minus sign, but no fields.

any idea what i'm doing wrong?

Thanks,
Craig

3 replies

by anthony m

Well that's very bizarre. I tried to reproduce your problem hooked into both a '97 and 2000 mdb file with no problem and saw the fields. I even tried it with a password protected database and it asked me for the password before it would display the Query Wizard Dialog.

Are you following these steps exactly: -
1. Data | Get External Data
2. Create New Query
3. Scroll and select Microsoft Access (whatever)
4. Click Ok and a file dialog comes up with *.mdb and you choose your database.
5. The Query Wizard choose columns dialog pops up

You may have to repair the either the installation of office, or run a repair on the Access database, the indexes may have gone screwy.

Hope this helps

This discussion is closed to new replies.