Use Excel db file to complete Word form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Word and Excel 2003. I have an existing Word form that employees use
to initiate a corrective action request. I want to be able to take the data
from the Word form fields and enter it into an Excel database file to be used
as a log of complaints. How do I do this?
 
Hi =?Utf-8?B?R2VvY2hhbmQ=?=,
I have Word and Excel 2003. I have an existing Word form that employees use
to initiate a corrective action request. I want to be able to take the data
from the Word form fields and enter it into an Excel database file to be used
as a log of complaints. How do I do this?
Click to expand...
Well, a form can be saved as "data only", which creates a delimited text file.
This can be imported into an existing Excel table (Data menu).

The other way would be to use a macro to transfer the data. The place to follow
up on this is approach one of the word.vba newsgroups.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
Back
Top