Question How to handle a PDF file

[EricB]

I've already made an access application that does the work i expect it to do.
Now I want to make things a little faster.

I now receive by email a PDF form (or file) filled in by a customer. I open it with Acrobat Reader and then manually enter the information contained in the PDF file into a new record in my database.

Now I would like my application to read that file and fill in a new record by itself.

Would somebody know how to do this or at least put me in the good direction.

Thank you

EricB

 

[spikepl]

There is a free application capable of reading a PDF-file and converting it to eg a text file. I launch it using the shell command, wait a while for it to finish, and then gobble up the resulting text file. http://en.wikipedia.org/wiki/Pdftotext

 

[EricB]

Can this be done IN my application or I have to manually transform the PDF and then feed the text version to my access application ?

 

[spikepl]

I launch it using the shell command,

in access

gobble up the resulting text file

in access - you need to write code to read the file