MS word forms and access

[Guest]

I want to email someone an MS word form to input information and email it
back to me with the entered data. When the person emails the document back to
me, I want to be able to transfer the data in the MS word form to an Access
database.
Is this possible?

 

[ManningFan]

Probably, but I would think it'd be awfully "cludgey". Why not just
email them a scaled down version of the database with a form to accept
their data, then just append the record to your database when you get
it back?

 

[Guest]

how is it done?

Probably, but I would think it'd be awfully "cludgey". Why not just
email them a scaled down version of the database with a form to accept
their data, then just append the record to your database when you get
it back?

 

[jahoobob via AccessMonster.com]

This from Word Help:

Save form data for use in a database or spreadsheet
1. Open the document that was filled in as a form in Microsoft Word.
2. On the Tools menu, click Options, and then click the Save tab.
3. Select the Save data only for forms check box.
4. Click OK.
5. On the File menu, click Save Copy As.
6. Type a file name in the File name box.
7. In the Save as type box, select Plain Text, and then click Save.
8. Select a text encoding option, and then click OK.
9. Word saves the form field data in a comma-delimited text file.


You can thne import the text file into Access.

 

[Peter R. Fletcher]

Lots more people have Word on their systems than have Access. Word
Forms are probably the right way to go, and it is is easy to dump the
data from them ito a formatted .txt file that can be handled by
Access. Look at Help in Word for "Save Form data".

Probably, but I would think it'd be awfully "cludgey". Why not just
email them a scaled down version of the database with a form to accept
their data, then just append the record to your database when you get
it back?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher