Capturing PDF data

[MDJ52]

I receive a large number of files daily that we use for populating our ACCESS databases. These files are in PDF format. Right now I have a hot button on the ACCESS form to open in Acrobat Reader the file. We are then forced to either cut and paste or to just look at the form and then hand-type the data on to the ACCESS form.
Is there a way in VB to capture the data from a PDF file. I have done a number of loops on text and HTML files that have been successful using the DIR$ option to capture the file names into an array.
Is there a way to capture this PDF data.
Thanks.

 

[HenryAnthony]

This is not an answer but maybe some help. I share your situation. You will need Adobe Acrobat, not reader, to export form data, with a .fdf extension (under file menu). You get a file something like this. You can open it in NotePad. Included fields are: Department, Date, Name, Phone, Title.

%FDF-1.2 %âãÏÓ
1 0 obj << /FDF << /Fields [ << /V (IT)/T (department)>> << /V (01/01/01)/T (date)>> << /V (Henry)/T (name)>>
<< /V (555-555-5555)/T (phone)>> << /V (Big Kahuna)/T (title)>> ] /F (App.pdf)>> >>
endobj trailer << /Root 1 0 R >> %%EOF

I have been trying, without success to parse this into an access table. Any ideas? I could probably do some text search and replace but that would not be worth the effort in this instance.

You can also set the PDF form up to send the form data to a URL as CGI values. Unfortunately I do not have that luxury.

 

[Pistol]

I have users submit data via a PDF form to a database (via the browser and Acrobat reader)

If you want shoot me an email and I wil forward each of you the ASP files.

pmclernon@us.belimo.com

 

[Pistol]

I have posted the PDF files on my website, Just save to disk at prompt:

http://www.mclernon.com/peter/ASP/Loan_process.zip

 

[HenryAnthony]

Thanks for keeping this thread alive )

Best regards,

Henr¥