Microsoft Query could not be started because it isn't installed

[MalcolmW]

A couple of days ago I posted the message hereunder in the excel.general
group & there has not been a response. Had I been more observant in looking
at the list of groups I am sure it would have been more appropriate to post
my message here & I am hoping for some kind of helpful reply!

This is my message:

I have Excel 2000 SP3 & Windows XP Home. When I go to Data | Get External
Data | Run Saved Query I can import data from an Access database into an
Excel worksheet. When I go to Data | Get External Data | New Database Query
after a delay a message appears to tell me that MS Query is not installed.
This is the message:

"Microsoft Excel
"Microsoft Query could not be started because it isn't installed. You can
install Query by running the installation program you "used to install
Office or Excel. The Query option is in the Office Tools category.
"OK"

However MSQRY32.EXE is in the Office folder & I have reinstalled it by
renaming it to .old & running the Add/Remove facility in the Office
installer to no avail. I have also installed the complete set of Office
Tools without any change in the above-mentioned behaviour. I have run
Detect & Repair again with no change.

I have searched the MSKB & found an article at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;179686
that refers to this problem but in Microsoft Excel 98 Macintosh Edition.
Nevertheless I have tried the resolutions from the article again to no
avail. When trying to start MS Query by double-clicking MSQRY32.EXE apart
from the display blinking MS Query does not open. Task Manager both in
applications & processes does not show that it is running.

It seems to me that as a Saved Query can be run that Query is installed &
that some other element that Excel, Query & Access need for a New Database
Query is either absent or not available.

Can anyone help with this difficulty please?

Malcolm

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[MalcolmW]

I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace
the files of the same name in MS Office I now can access MS Query in MS
Excel 2000 through Data | Get External Data | New Database Query. The two
files of have the same name but different date/time stamps & volumes in each
suite.

Malcolm Walker

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.

 

[Gerry Hickman]

Hi,

I had a quick look at this on Excel 2000 SP3, and note that when you
choose "Data | Get External Data | New Database Query", it enumerates
ODBC sources and then offers them.

On my system it's fast, and works perfectly, but I wonder if your ODBC
was messed up in some way? You can check it under "Administrator Tools"
on the start menu of Windows 2000, not sure where it would be on XP.

Maybe the fact you had Works has messed up the registry mappings? I
don't recommend running Works and Office on the same PC.