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



"Ian" wrote:

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

"CLR" wrote:

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



"Ian" wrote:

I have a problem when I select DataGet External DataNew 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