MS Query in Excel, saving SQL changes

[CruiseMan]

I am using Excel 2000 and have generated a query against an Oracle database. The query works fine. When I edit the "Order By" clause of the query in the SQL window and run it, it also works fine then and populates the worksheet. However, if I exit Excel and return, I lose the edits I made to the original SQL. What am I overlooking? The query itself uses 2 joined tables, if that makes a difference.

 

[SkipVought]

Please post your SQL. Explain where your edits are that you are not seeing in the resultset in Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlbo]

If you are using MSQuery, you need to select the "Save and return data to Excel" option - this should save the query definition. If that doesn;t work, right click on the querytable and select "Data Range Properties" and untick "Save Query Definition" - then make your changes and return the data. Once you have done that and the changes have been saved, re-tick the "Save Query Definition" box

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question