Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

How to change an existing query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gireeshm - 18 Jul 2006 12:23 GMT
Hi All

I have been using excel more than a year. I have a tool that contains a
query in one of the sheets which will coonect to an oracle database and
retrieves the data. Now I have to change the query. Is this possible
for me change only the query with out disturbing the other
functionality and structure of the tool. Please help me in this regard
as soon as possible.

Thanks and Regards
Gireesh

Signature

Gireeshm

Ron Coderre - 18 Jul 2006 19:31 GMT
Possibly....but, first a few questions:

What do you mean by "tool"? (An Excel application?)
What other functionality are you concerned about being impacted by a
query change?
Does it contain VBA programming to connect to Oracle or does it use MS
Query?
Do you have the current SQL command? Is it a complete query or does it
run a stored procedure?
What have you tried so far to access the SQL?
What do you think might prevent you from changing it?

Regards,
Ron

Signature

Ron Coderre

Huff - 19 Jul 2006 13:34 GMT
Hi

Just to check:

To edit an exisiting query you can right click on a cell that has
results in it from the query, and select 'Edit Query' from the bottom
of the options. This brings up a query wizard window. I'd expect that
you'd need the main MS Query screen to edit your query, so cancel the
wizard and continue editing in MS Query. Here you should see a view of
the table(s) you're connecting too and any criteria or joins. There's
also a SQL button to edit the query directly in SQL.

The above is a simplistic approach in case that's what you need -
otherwise Ron's previous post should be looked at instead of this!

Cheers

> Hi All
>
[quoted text clipped - 13 lines]
> Gireeshm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36478
> View this thread: http://www.excelforum.com/showthread.php?threadid=562406

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.