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.
|