Questiopn: PDF form data in Access

[Guest]

i have a bunch of PDF forms filled out by different users. How do I import
the data from these PDFs into an Access table?

thanks

 

[Paul Overway]

You'd have to save each PDF as text, and then parse the result. There is no
native import feature in Access for importing PDF files.

 

[Guest]

Is there a PDF export format that access could then work off of?

 

[Paul Overway]

Yes...as I suggested....text.

 

[Guest]

Yes ... but in Adobe Acrobat there is not an "Text" option in the export
menu. So, how do i export the form as text?

 

[Paul Overway]

You have to do "Save as". Then you select text as they file type.

 

[Guest]

thanks

You have to do "Save as". Then you select text as they file type.

 

[Albert D. Kallal]

Is there any other formats available like csv, or comma delimited available?
(ms-access can import those).

 

[Jesse Aviles]

If you are using Adobe Acrobat you can export the form field info to XML and then import it to
Access. You will need to write some code to do it.