Save Data Only for Forms

[SoCal Rick]

I have a large word file that uses over 100 text formfields. When the user
opens the Doc file, they are presented with a series of Userforms. They
click check-boxes, click option-buttons and enter data in text boxes. At any
point they can see the impact of their selections in the word document. When
they are done they save the document. As part of the save process, a txt
file is created.
When everyone is done filling out the forms and saving the documents, the
files are collected on a flash drive and loaded to a central computer.
I'd like to be able to load each of the txt file into an Access database.
However, the formatting ","...","............"," does import well into
Access. I'd like to change the format of the txt file so one text form field
is on each line.
Or, I'd like to figure out a better way to get the data to Access. Any
ideas would be welcome.
Thank you,
Rick

 

[Doug Robbins - Word MVP]

See the last of the series of articles at:

http://www.mousetrax.com/techpage.html#autoforms


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP