Excel and Query

[Guest]

I have a spreadsheet that queries an ODBC database using Microsoft Query. I
would like to change the destination cells for the query result, but can't
find a way of doing that. Alternatively I would like to delete the query and
write another, but can't find a way of deleting the query.

Can anyone help?

Many thanks

 

[Sunil Jayakumar]

Hi,

To get rid of the query:
You will be able to find the query range by using the drop down box on the
top left (where it usually refers to the active cell). Once you find this,
you can select the range, and selete the cells (Use Ctrl+-).
Another way is to go to Insert>Name>Define and delete the range from there.

To Move the query, simply selct the query range (as above), click on a
handle in the corner, and drag it to wherever you want it placed - you can
even cut and paste it.

Hope this helps

Sunil Jayakumar

I have a spreadsheet that queries an ODBC database using Microsoft Query.
I
would like to change the destination cells for the query result, but can't
find a way of doing that. Alternatively I would like to delete the query
and
write another, but can't find a way of deleting the query.

Can anyone help?

Many thanks

www.ayyoo.com/credit-cards.html