Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

Export Text Fields from Word Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 25 Nov 2003 20:56 GMT
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?
Peter Jamieson - 26 Nov 2003 05:53 GMT
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).

--
Peter Jamieson - Word MVP

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.