Microsoft Query


G

Guest

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

Advertisements

G

Guest

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

Guest

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

Jake Marx

G

Guest

Thanks so much for this information.
It may give me some clues as to work arounds.

Jake Marx said:
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...read/thread/e516d61dcc1f8df9/72207e5aa80705a2

http://groups-beta.google.com/group...read/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]

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

Advertisements

G

Guest

I just posted the EXACT question. I have been on 8i for over a year and I
haven't had any issues what so ever. Of course I did have to add 'SQL net8
Version 8.1.7.0.0' Oracle. (provided by my POS vender)
So its not an 8i issue. I just started getting the error today!
Let me know if you find anything. I'll do the same

(e-mail address removed)
Gary

gsteck said:
Thanks so much for this information.
It may give me some clues as to work arounds.

Jake Marx said:
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...read/thread/e516d61dcc1f8df9/72207e5aa80705a2

http://groups-beta.google.com/group...read/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]

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.

:

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.


:

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top