Have created a dynamic form comprising 4 subforms, one of which can have up to 50 instances. Each of the subforms requires user input into various text fields and dropdown lists. The subform that can have up to 50 instances has 14 text fields/dropdown lists.
My problem is that if I receive say 15 completed forms with differing numbers of completed instances how can I extract the data into say an Access database table or tables? The spreadsheet option in Acrobat Pro XI creates rows of varying field lengths (identifying the form row number in long text hierarchy format) which requires lengthy cutting and pasting into a table format.
Is it possible to directly extract the input data from multiple completed dynamic forms into an Access database table or tables? Can anybody help me?