On Sep 18, 5:16 pm, shelley_2000 <shelley_2...@comcast.netwrote:
What is the best approach to collect and load Employee Resume Data
from External Employees who may not have Microsoft access? If is
likely they will have Microsoft Word, but not Microsoft Access.
Is there any type of form/template that I could send to employees to
fill out and send back for me to import into the Access Database?
Or should I consider a Word Forms with some type of data extractor for
loading into Access database? and if so, what type of extractor
mechanism should I use?
If it worked, you would have to import them one at a time. A better
solution is to allow them to input the data through a company
website. If you have to do it the hard way, then you have a couple of
choices:
1) Send out a Word doc, and have them fill it in, send it in, and then
you (or someone) would type it in.
2) Use VBA and Word to create an input sheet that validates data and
exports the data to a textfile.
The second option is possible, but it would take a great deal of
time. How many employees are we talking about? If it is less than
20, then option 1 is the faster way.