How do I do this with Office 2003?

M

mikebo

I need to collect information on a recurring basis from a number of people
who are in different parts of the world. The information then needs to be
entered into a database for further evaluation. What is the best way of doing
that?

Right now, they send me documents (Word, PDFs), that need to be entered
manually. I would like to automate the whole task. Where can I find
information on how this can be done? We all use Outlook, so an outlook form
might be the way to go, but I don't know how the data in an outlook form can
be transferred automatically into an Access Database. Another possibility
might be to have the people fill out Excel sheets, but again, how can the
data be transferred automatically into an Access Database. Does anyone have
any suggestions for me where to look?

Thanks.
 
M

mikebo

Would that require to have the full version of Adobe Acrobat? Is there a way
to get this done within the Office suite?

JoAnn Paules said:
..pdf forms can be created to allow the input to be saved in a table that you
could import into Excel or Access.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




mikebo said:
I need to collect information on a recurring basis from a number of people
who are in different parts of the world. The information then needs to be
entered into a database for further evaluation. What is the best way of
doing
that?

Right now, they send me documents (Word, PDFs), that need to be entered
manually. I would like to automate the whole task. Where can I find
information on how this can be done? We all use Outlook, so an outlook
form
might be the way to go, but I don't know how the data in an outlook form
can
be transferred automatically into an Access Database. Another possibility
might be to have the people fill out Excel sheets, but again, how can the
data be transferred automatically into an Access Database. Does anyone
have
any suggestions for me where to look?

Thanks.
Click to expand...
Click to expand...
 
J

JoAnn Paules

Yes, you do need the full version. And the professional edition at that -
but it can be done. Because I have that I can't help with any Office only
solutions.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


mikebo said:
Would that require to have the full version of Adobe Acrobat? Is there a
way
to get this done within the Office suite?

JoAnn Paules said:
..pdf forms can be created to allow the input to be saved in a table that
you
could import into Excel or Access.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




mikebo said:
I need to collect information on a recurring basis from a number of
people
who are in different parts of the world. The information then needs to
be
entered into a database for further evaluation. What is the best way of
doing
that?

Right now, they send me documents (Word, PDFs), that need to be entered
manually. I would like to automate the whole task. Where can I find
information on how this can be done? We all use Outlook, so an outlook
form
might be the way to go, but I don't know how the data in an outlook
form
can
be transferred automatically into an Access Database. Another
possibility
might be to have the people fill out Excel sheets, but again, how can
the
data be transferred automatically into an Access Database. Does anyone
have
any suggestions for me where to look?

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Top