How to change an existing query

[Gireeshm]

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

 

[Ron Coderre]

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

 

[Huff]

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