Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 "CLR" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 "CLR" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 "CLR" wrote: 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 "CLR" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 "rasinc" wrote: 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 "CLR" wrote: 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 "CLR" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query will not start from Excel 2000
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 FilesMicrosoft office. Renamed the Office folder in Documents and SettingsAll UsersApplication DataMicrosoft. I then ran MS Office 2003 resouce kitremoval 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 DataNew Database QueryGet external dataNew Database Query, but MSQuery will not start , window just hangs forever. Any ideas please, getting desperate now! Ian "CLR" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 freezes when I try to Copy & Paste after start-up. | Excel Worksheet Functions | |||
Excel 2000 bad start up | Setting up and Configuration of Excel | |||
Edit query in excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 hangs on new database query XP | Excel Discussion (Misc queries) | |||
Help! Excel 2000 fully SP'ed will not start | Excel Discussion (Misc queries) |