MS Query will not start from Excel 2000

I

Ian

I have a problem when I select Data>Get External Data>New Database Query,
Excel hangs with this message at the bottom of the Excel window
'Waiting for data to be returned from Microsoft Query'

I can start MS Query directly from MSQRY32.EXE and retrieve all the data I
need, but not into Excel.

Office is all upto date to SP3. PC is running XPv2002 SP3.
Any help would be much appreciated.
Thanks
 
C

CLR

The steps you outline would normally return a dialog box wanting you to
select a Data Source, etc.......assuming you go through all that properly and
still get the same Error message/hang, it's probably because the source
cannot be found, nor that you do not have approved access to it from that
login.

Vaya con dios,
Chuck, CABGx3
 
C

CLR

The steps you outline would normally return a dialog box wanting you to
select a Data Source, etc.......assuming you go through all that properly and
still get the same Error message/hang, it's probably because the source
cannot be found, nor that you do not have approved access to it from that
login.

Vaya con dios,
Chuck, CABGx3
 
I

Ian

Thanks for the reply.
I agree, normally Query would start and you could select the required data.
As explained I can run Query from MSQRY32.EXE has find the data, but I need
it going straight into Excel so that I can refresh data in the future.
Any help would be appreciated.

Ian
 
I

Ian

Thanks for the reply.
I agree, normally Query would start and you could select the required data.
As explained I can run Query from MSQRY32.EXE has find the data, but I need
it going straight into Excel so that I can refresh data in the future.
Any help would be appreciated.

Ian
 
C

CLR

I would suggest that you try starting MSquery from Excel again, only this
time try to access a simple ACCESS file that you just create and therefore
KNOW that you have access rights to.......if that works, then your original
problem is probably what I said before, that the file cannot be found or you
do not have rights to it.......if it does not work, then it could mean that
either your Excel or your MSQuery install is corrupt.

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

I would suggest that you try starting MSquery from Excel again, only this
time try to access a simple ACCESS file that you just create and therefore
KNOW that you have access rights to.......if that works, then your original
problem is probably what I said before, that the file cannot be found or you
do not have rights to it.......if it does not work, then it could mean that
either your Excel or your MSQuery install is corrupt.

Vaya con Dios,
Chuck, CABGx3
 
R

rasinc

I'm having the same problem as Ian. Was working fine with Excel a couple of
months ago. I ran Detect and Repair and inserted my original CD when
prompted. No errors and it completed fine. I can create a query running
msqry32.exe, save it to the hard drive and insert it into a spreadsheet but
cannot edit it after either. It runs fine on my Win2K machine but not on my
WinXPSP2 machine even though it was earlier this year. It is not a rights to
the database issue as I can run a query but cannot get to the ODBC drivers in
Excel. The dialog doesn't show up.

Anyone with ideas, greatly appreciated. TIA rasinc
 
R

rasinc

I'm having the same problem as Ian. Was working fine with Excel a couple of
months ago. I ran Detect and Repair and inserted my original CD when
prompted. No errors and it completed fine. I can create a query running
msqry32.exe, save it to the hard drive and insert it into a spreadsheet but
cannot edit it after either. It runs fine on my Win2K machine but not on my
WinXPSP2 machine even though it was earlier this year. It is not a rights to
the database issue as I can run a query but cannot get to the ODBC drivers in
Excel. The dialog doesn't show up.

Anyone with ideas, greatly appreciated. TIA rasinc
 
C

CLR

I have two different databases at work, MP2 and ManMan and each required the
MIS dept to put in special permission for me to access them via my
queries.....I don't know how or why, but it would not work until/unless they
gave their permissions. Whenever I do a query, I record a macro in Excel
while I do it,.... and when it is done, I now have a macro that I can
edit.....sometimes the editing can be tedious, but it can be done.........

hth
Vaya con Dios,
Chuck, CABGx3
 
C

CLR

I have two different databases at work, MP2 and ManMan and each required the
MIS dept to put in special permission for me to access them via my
queries.....I don't know how or why, but it would not work until/unless they
gave their permissions. Whenever I do a query, I record a macro in Excel
while I do it,.... and when it is done, I now have a macro that I can
edit.....sometimes the editing can be tedious, but it can be done.........

hth
Vaya con Dios,
Chuck, CABGx3
 
R

rasinc

Well, after a good night sleep it seems to be working again. I guess the
Detect and Repair needed a reboot that I didn't do yesterday.

Thanks
 
R

rasinc

Well, after a good night sleep it seems to be working again. I guess the
Detect and Repair needed a reboot that I didn't do yesterday.

Thanks
 
C

CLR

Glad you got it sorted. Those things are a real pain when they act up, but
once they get setteled in, they seem pretty stable.....

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Glad you got it sorted. Those things are a real pain when they act up, but
once they get setteled in, they seem pretty stable.....

Vaya con Dios,
Chuck, CABGx3
 
I

Ian

I have tried your first suggestion but cannot start MSQuery from within
Excel. Have checked the Addins which confirms that it is installed.
Following your suggestion that Office may be corrupt, I uninstalled MS
Office , renamed all folders in Program Files>Microsoft office. Renamed the
Office folder in Documents and Settings>All Users>Application
Data>Microsoft>.
I then ran MS Office 2003 resouce kit>removal tool, which is suppost to
remove all previous version of Office.
Then reinstalled Office, but when I ran Excel it did not go to 'first use'
so must be retaining some previous settings and maybe the problem ones! Then
tried Excel > Data>New Database Query>Get external data>New Database Query,
but MSQuery will not start , window just hangs forever.
Any ideas please, getting desperate now!

Ian
 
I

Ian

I have tried your first suggestion but cannot start MSQuery from within
Excel. Have checked the Addins which confirms that it is installed.
Following your suggestion that Office may be corrupt, I uninstalled MS
Office , renamed all folders in Program Files>Microsoft office. Renamed the
Office folder in Documents and Settings>All Users>Application
Data>Microsoft>.
I then ran MS Office 2003 resouce kit>removal tool, which is suppost to
remove all previous version of Office.
Then reinstalled Office, but when I ran Excel it did not go to 'first use'
so must be retaining some previous settings and maybe the problem ones! Then
tried Excel > Data>New Database Query>Get external data>New Database Query,
but MSQuery will not start , window just hangs forever.
Any ideas please, getting desperate now!

Ian
 
Joined
Oct 14, 2009
Messages
1
Reaction score
0
I stumbled upon this thread while researching the dreaded "Waiting for data to be returned from Microsoft Query" in Excel 2000 that hangs forever. I had exactly the problem the Ian describes and tried all the suggestions but the problem remained. Using the task manager or process explorer shows MSQRY32 never starts. The hardware is quite dated: IBM T30 notebook, Win 2K SP4, Office 2K SP3.
Quite accidentally I discovered that I can run an External Data query from within Excel 2000 if I removed the D-Link DWA-652 wireless card I sometimes use. If I boot with the card, Data>Get External Data>New Database Query hangs. If I boot without the card, Data>Get External Data>New Database Query works. Completely repeatable. I downloaded and installed new drivers from D-Link and now the problem has vanished.
My apologies for dredging up an old thread however, I did want to share my resolution to the problem. Carry on.
 

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


Top