Re: Microsoft Query

From: Jake Marx (msnews_at_longhead.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 16:38:25 -0700

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/microsoft.public.excel/browse_thread/thread/e516d61dcc1f8df9/72207e5aa80705a2

http://groups-beta.google.com/group/microsoft.public.excel.querydao/browse_thread/thread/270d1fcfa72702d6/40e28e566b663026

http://www.tek-tips.com/viewthread.cfm?qid=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 spread*** 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
>>> spread***.
>>> Any help would be appreciated.
Quantcast