Thread: [Solved] Put Word forms into an Access database
View Single Post
 
Old 11-06-2014, 10:45 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
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
Reply With Quote