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