Appending Information From Read only PDF into MS Access

[Kody_Devl]

Hi All,

Does anyone have a slick way to find information in a read only PDF and then appending the information into an access table or excel spreadsheet?

For Example, I want to scan Non-standard Homeowner's insurance policies to get (each policy is a different format but has the same core information):


1. The Start Date of the Policy
2. The End Date of the Policy
3. Name of the Investor
4. Face amount of the policy.

I know how to use Access to find and convert the PDF to editable.
I was thinking of pasting the 1-3 page policy into a Memo field and find the data, somehow from the MEMO field to search.

If I can't fully automate, I am OK with semi-automated to get this information in 1 Minute instead of 15 Minutes.

The users are currently opening and reading these policies thru a cumbersome interface, finding and keying a few data fields from the pdf into that application's form. This is taking up to 15 Minutes per document.

Any suggestions would be greatly appreciate.

Thank you

Kody_Devl

[orange]

See the approach suggested by Albert Kallal here.

[CarlettoFed]

15 Minutes to store the 4 data?
1. The Start Date of the Policy
2. The End Date of the Policy
3. Name of the Investor
4. Face amount of the policy.
To help you it would be necessary to see all the different types of PDF to see if there are still the common data to search for the 4 data above, as long as there are no other things to recover.

[Gicu]

If the labels are consistent (like Start Date, you can use them as keywords and use InStr to find them. Have a look at the free parser utility I have on my website, it can be probably used as a starting point for you.
http://forestbyte.com/ms-access-utilities/fba-outlook-email-parser-importer/#content-content-inner
Cheers,