Thread: Microsoft Query
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kirk P. Kirk P. is offline
external usenet poster
 
Posts: 66
Default 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.