|
Microsoft Query
We have been using MS Query for several years to bring information from a
Unix based database, via an ODBC connection. We recently upgraded from Oracle 7 to Oracle 8i and though I can create new queries without any problems, I cannot go back and edit the query for some reason. I get a message 'waiting for data to be returned from MS Query' but then it disappears and leaves me at the spreadsheet. Any help would be appreciated. |
Microsoft Query
I can't speak directly to your problem with MS Query, but if you are familiar
with MS Access, I would use Access to pull the data from your Oracle tables and create a local table within Access. You can then ODBC connect Excel to the Access table you created. "gsteck" wrote: We have been using MS Query for several years to bring information from a Unix based database, via an ODBC connection. We recently upgraded from Oracle 7 to Oracle 8i and though I can create new queries without any problems, I cannot go back and edit the query for some reason. I get a message 'waiting for data to be returned from MS Query' but then it disappears and leaves me at the spreadsheet. Any help would be appreciated. |
Microsoft Query
We use many Access Databases as well, but MS Query allows the end users to
refresh data quickly and easily without having to open a database. The data gets put directly into a spreadsheet and can be manipulted from there. It also prevents accidental changing or deleting data in the database. "Kirk P." wrote: I can't speak directly to your problem with MS Query, but if you are familiar with MS Access, I would use Access to pull the data from your Oracle tables and create a local table within Access. You can then ODBC connect Excel to the Access table you created. "gsteck" wrote: We have been using MS Query for several years to bring information from a Unix based database, via an ODBC connection. We recently upgraded from Oracle 7 to Oracle 8i and though I can create new queries without any problems, I cannot go back and edit the query for some reason. I get a message 'waiting for data to be returned from MS Query' but then it disappears and leaves me at the spreadsheet. Any help would be appreciated. |
Microsoft Query
Hi gsteck,
Do either of these help? At least the second link indicates you're not alone and that Oracle is aware of the issue (and blames it on MS). http://groups-beta.google.com/group/...207e5aa80705a2 http://groups-beta.google.com/group/...e28e566b663026 http://www.tek-tips.com/viewthread.c...=987340&page=3 -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] gsteck wrote: We use many Access Databases as well, but MS Query allows the end users to refresh data quickly and easily without having to open a database. The data gets put directly into a spreadsheet and can be manipulted from there. It also prevents accidental changing or deleting data in the database. "Kirk P." wrote: I can't speak directly to your problem with MS Query, but if you are familiar with MS Access, I would use Access to pull the data from your Oracle tables and create a local table within Access. You can then ODBC connect Excel to the Access table you created. "gsteck" wrote: We have been using MS Query for several years to bring information from a Unix based database, via an ODBC connection. We recently upgraded from Oracle 7 to Oracle 8i and though I can create new queries without any problems, I cannot go back and edit the query for some reason. I get a message 'waiting for data to be returned from MS Query' but then it disappears and leaves me at the spreadsheet. Any help would be appreciated. |
Microsoft Query
Thanks so much for this information.
It may give me some clues as to work arounds. "Jake Marx" wrote: Hi gsteck, Do either of these help? At least the second link indicates you're not alone and that Oracle is aware of the issue (and blames it on MS). http://groups-beta.google.com/group/...207e5aa80705a2 http://groups-beta.google.com/group/...e28e566b663026 http://www.tek-tips.com/viewthread.c...=987340&page=3 -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] gsteck wrote: We use many Access Databases as well, but MS Query allows the end users to refresh data quickly and easily without having to open a database. The data gets put directly into a spreadsheet and can be manipulted from there. It also prevents accidental changing or deleting data in the database. "Kirk P." wrote: I can't speak directly to your problem with MS Query, but if you are familiar with MS Access, I would use Access to pull the data from your Oracle tables and create a local table within Access. You can then ODBC connect Excel to the Access table you created. "gsteck" wrote: We have been using MS Query for several years to bring information from a Unix based database, via an ODBC connection. We recently upgraded from Oracle 7 to Oracle 8i and though I can create new queries without any problems, I cannot go back and edit the query for some reason. I get a message 'waiting for data to be returned from MS Query' but then it disappears and leaves me at the spreadsheet. Any help would be appreciated. |
| All times are GMT +1. The time now is 11:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com