Importing data from word 2002 forms into Access tables

[HowardB]

Hi All,

I am looking for some example code from someone who has done this kind of thing before using Office 2002 apps.

Basically I want to create a form in Word that has inserted data fields (can do that)which can be emailed to users to fill in information. The fields could be numeric, date or text.

Completed form then emailed back to me.

Then want some Access VBA code to take info. entered in the word form and transfer this to table in access, creating a new record for each instance of a form dataset

Not sure whether the best approach is to associate the VBA "transfer" code with the access database or with a "Save Button" macro on the Word form (ie push or pull the information across?)

If anyone has some code snipetts they can post to give me a start that would be great

 

[vbajock]

If you want to process data off the word document that has undergone some type of change, wouldn't it make sense to use Access to pull the final version into a directory and then process them from there?

 

[HowardB]

Hi vbajock,

Thanks for the post, any ideas about the coding aspects?

HB

 

[vbajock]

http://msdn.microsoft.com/library/d.../modcore/html/detskmicrosoftword2002page7.asp

gives a description of the Word object model