Export Text Fields from Word Form

S

Steve

Is it possible to export or in some way get at the data
that has been put in a Word Form with Bookmarks so the
data can be brought into a database with out retyping?
 
P

Peter Jamieson

There are probably a couple of ways you can do this assuming by "Word Form"
you mean "Online form", e.g. created using Word's Forms toolbar (but maybe
you could clarify "put into a Word Form with Bookmarks"):
a. if all the user data is actually inserted using form fields, check Word
Tools|Options|Save|"Save data only for forms" (or more likely, do the
equivalent in VBA which is

ActiveDocument.SaveFormsData = True

then save the file. This puts the data into a delimited text file which you
can import into your database. However, it does not save a line of headings
so you may need to provide those separately)
b. use Word VBA to retrieve the value of each form field (or bookmark),
then use e.g. ADO to update your database directly (assuming it can be
accessed using ADO) or save the values to a delimited text file and import
them as in (a).
 

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

Top