Form/template to pull information from access database

How do I create a master form/template in excel that will pull the
information from access? This needs to be emailed on to other individuals
who will input certain information. Therefore, some of my fields need to be
locked leaving some open for data entry.

I thought that perhaps a query imported from access to excel and then the
form populated by excel. Once the individual inputs info and emails back,
that info will populate my excel query.

The thought is all I have as I have never attempted anything like this and
have absolutely no idea as how to go about. I may be on the wrong track
also.

Your assistance is appreciated.

JR

I really need help on this. I have a time line that is getting short. My
apologies for second post.
"jwr" <joyrose@bellsouth.net> wrote in message
news:8D%Oe.27606$xW.27348@bignews6.bellsouth.net...
> How do I create a master form/template in excel that will pull the
> information from access? This needs to be emailed on to other individuals
> who will input certain information. Therefore, some of my fields need to
be
> locked leaving some open for data entry.
>
> I thought that perhaps a query imported from access to excel and then the
> form populated by excel. Once the individual inputs info and emails back,
> that info will populate my excel query.
>
> The thought is all I have as I have never attempted anything like this and
> have absolutely no idea as how to go about. I may be on the wrong track
> also.
>
> Your assistance is appreciated.
>
> JR
>
>