Question Locked

MS Query missing in Excel

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

I am running Excel 2000 and need to get external data, new database query. I get the message that MS Query is not installed, do you want to install it. But when I put in my original Office CD says it isn't valid for reload, presumably because I updated Office on-line with a service pak or something. Now it is called "Premium" version, but my original CD is just Office Pro.

How can I get the MS Query update?

J. Erwin

2 replies

by Former member

First, we?ll make sure Query is installed. If you have Excel 2003 it?s installed automatically, but with Excel 2000 or Excel 97 it?s a non-standard add-in and if it is not installed you will need your original Office disks.

Starting up Query ? Excel 2003
Start up Excel. Open a new workbook and click onto cell A1. (with Query you have to have start with a workbook open. Otherwise all the menu options are greyed out)

From main menu select: Import External Data ? New Database Query. The ?Choose Data Source? box appears, meaning Query is ready to go.

Starting up Query ? Excel 2000 or Excel 97
If you have Excel 2000 or Excel 97 and Query is not installed, you will need your MS Office disks.

Start up Excel. Open a new workbook and click onto cell A1. (with Query you have to have start with a workbook open. Otherwise all the menu options are greyed out)

From main menu select: Get External Data ? Create Database Query. The ?Choose Data Source? box appears.

If Query isn?t installed, Excel asks if you want to install it. Insert your MS Office disks as instructed.

Once Query is installed, you may also need to activate it. From main menu choose Tools ? Add-Ins. My copy of Excel 2000 has a box called MS Query, my copy of Excel 97 has a box called MS Query for Excel 5. I?m not sure what these are, but it?s probably best to tick them. There?s also a box called ODBC setup but that doesn?t seem to matter. (If you've got version 10 or more of Line 50, you may see a box for Sage EIR Excel Integrated Reporting as well.)

Once you?ve installed Query and the Choose Data Source box is on the screen, you?re ready for the next step - to set up Sage as your data source, Or what ever data source you have. Hope all works out for you.

Or read more here:
http://office.microsoft.com/en-us/excel/HA100996641033.aspx

Please post back if you have any more problems or questions.

This discussion is closed to new replies.