Export from word to access

M

Mario Valdivia

How can I export words fields to access tables through macros?
Thanks for your help
 
B

Bill Foley

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
 

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