Nick,

Now that I've gotten that bit figured out, I've had another problem.

One query I want to run in my Excel spreadsheet is to create a list of
a person's children.

I'd prefer my table of children to be just the right size for the
number of children, so if there are three children I want it to have
just three rows (plus the header) and if there are more children the
query should insert the extra rows as required.

The most promising looking option in the "external data range
properties" is "insert entire rows for new data, clear unused cells".
I select the entire row of the table as the destination for the data,
expecting that if there are two or more children it will just add new
rows as required.

Unfortunately, it instead inserts new columns to the left of the table
and puts the data there.

A simple workaround has been to make the children table longer than
necessary and use "Overwrite existing cells with new data, clear unused
cells" and then the children data gets plugged into the table as
desired. But then I've got extra rows which just need to be deleted
from the final document after I've broken all the links and am sending
the document to the intended recipient.

Any suggestions about what I'm doing wrong?

And one other question..

When I was first playing around with querying databases I managed to
accidentally link the database I was using to my list of available
databases, so rather than selecting "Access Database" and then
navigating to the database, I can just pick that database stright off
the list.

How do I repeat this trick? I'd like to add the database to my list,
which would save ten seconds of clicking every time I set up a new
query.

Thanks for your help.

Travis