importing forms in Excel

D

Doris

I've made an "on-line" form template in Word (Office
2000)and now have several documents filled out with client
info. Is there a way to import data from these multiple
form documents into a single Excel database/spreadsheet?

I need to share the Form documents with others as email
attachments so I can't use Access because the others don't
have Access.

Thanks.
 
D

Debra Dalgleish

If you create a form in Word, you can set it to save the Data only
(Tools>Options, Save tab, 'Save Data only for forms').

This will create a text file when you save it. You can import the text
files to Excel, and append them to your database.
 
Top