Import word form data into multiple tables in Access

S

Shell E

USING: Word 2003 & Access 2003

GOAL: I will be sending a Word Form to over 100 external employees for them
to enter Resume Data ( for e.g. Personal Data, Professional Experience,
Education, Certifications, and Skills (basically Resume Data). Please note
the different objects/tables.

GIVENS: I want to limit manual labor. Employees don't all have MS Access.
Employees don't have access to web because they typically lose secure id
card/fob.

I found an artilce
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/imo1200.asp)
on how to do this this via Access VBA when all the data is loaded into one
table. But, I have designed the database to have 1 to many relationships
between the objects (Skills, Professional Experience, Education,
Certifications).

QUESTION: Should I load all the Word Form data into one flat table and
somehow transform the flat record into the relational tables?

Or should I use Access VBA to load Word Form data directly into relational
tables?

Is there a better approach to acheiving my goal?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top