You should be able to connect/query through the External Data feature
explained earlier.
However, to edit some returned fields from excel back to access, there is no
built -in feature, it would therefore have to be programmed which is a more
intensive task.

At this point, first try to get the data into excel as explained above. Once
it is done and you are confortable with the External Data feature, post a new
question for the next step.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"jwr" wrote:

I have a query in access that contains 44 fields. I have created a report
from that query. I am attempting to get the query (or report - whichever
one works better in excel) to excel where I can "lock" all but 2 of those
fields. I will then email that portion of worksheet (Control number) that
pertains to a particular individual who will input the information into
those 2 fields and email back to me. Being able to send only information
that pertains to "Control number" is also a question of mine. Once I get
the email back - which may be more than one worksheet - with the fields
completed, I want to "put the worksheet back together" where I can email all
of the replies for all "Control Numbers"on to another individual rather than
emailing more than one worksheet per Control Number.

I would like the ability for the worksheet to refresh from my access as you
suggested. Also, is it possible for the "2 fields" be updated from excel
back to access?

What I am attempting may not be possible. Thank you for your prompt reply
and any assistance that you can provide. Again, I am definitely a novice at
this!