importing forms in Excel

  • Thread starter Thread starter Doris
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Browse button for access form 1
Importing information into Excel 1
Put form fields in Word forms into an Excel spreadsheet? 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how to import more than 1 text file into the same Excel worksheet. 1
import access to excel template 3
Import Filled out Order Form (.txt) into an excel database. 3
Excel=>Word help me please! 3

Back
Top