#1
|
|||
|
|||
Put Word forms into an Access database
What is the best way to transfer words forms into an Access table?
Ideally I would like to create a script that would loop through a folder, Copy Word Forms and transfer them into an Access table? Thanks, |
#2
|
||||
|
||||
I have an add-in (currently undergoing a major revision in response to user feedback - but will be published over the weekend) that extracts data from forms and puts it in an Excel worksheet. Excel to Access is a simple step. If that would work for you see http://www.gmayor.com/ExtractDataFromForms.htm.
I also have a similar add-in that takes e-mailed forms from Outlook and puts them in Excel or Access tables. See http://www.gmayor.com/extract_email_data_addin.htm However if you want help in rolling your own, it would be be necessary first to know whether the forms use Legacy form fields or Content Controls, as both are handled differently. Can we also assume that the table already exists, as that makes things somewhat simpler?
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
forms vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it possible to use an Access Database to merge specified PDF documents into word? | bgranzow | Mail Merge | 3 | 01-07-2014 09:41 PM |
get value from access database in normal line | alysolyman | Word VBA | 0 | 02-16-2013 12:41 PM |
get access database path in Word vba | marooned | Word VBA | 2 | 07-04-2012 06:37 AM |
How to link a combobox to an access database? | Joe Patrick | Word | 1 | 10-21-2011 09:01 AM |
Excel to lookup Access Database | PeterP | Excel | 1 | 06-11-2009 12:33 PM |