Export from word to access

  • Thread starter Thread starter Guest
  • Start date Start date
You can do this with one macro assigned to the "On Exit" of a specific field
in your document, but it requires some pretty good knowledge of VBA. You
need to make a connection to Access, access the database, access the table
you want, then make respective fields of that table equal to either the
value of a formfield or a variable that you make equal to the value of a
formfield. I use this process to take info from PowerPoint to Access.

If you are interested, I could provide a quick snippet of code that might
get you started. I don't have an example right now, but if I get time later
today, I might try and put one together.

The following site shows to do just the opposite (take data from Access and
place in Word):

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm
 
Back
Top