[AccessD] Any VBA code thats reads PDF

...you really need to talk to your client before investing so much time in 
something that most likely isn't going to work reliably anyway ...whoever is 
generating the pdf can almost certainly produce a usable file quite easily 
if they understood the problem ...or pay for you to have each report rekeyed 
on your end ...imnsho of course.

...clients are usually more than willing to fix such things once they 
understand that it is a cost driver.

William

--------------------------------------------------
From: "Edward Zuris" <edzedz at comcast.net>
Sent: Saturday, March 20, 2010 9:43 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Any VBA code thats reads PDF

>
> Thanks Stuart,
>
> I am already playing with a-pdf's PDFtoExcel product.
> And think I can automate it using a shell command.
>
> The scrambled eggs is the misleading text file that
> the PDF reader creates.  If said text file kept all
> the spaces then I could figure out the rest.
>
> I have worked with worse text file reports.
>
> I look into the cutePDF to see if I can use it.
>
> Thanks.
>
> Edz. . . .
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Saturday, March 20, 2010 3:10 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Any VBA code thats reads PDF
>
>
> PDF stands for Portable Document Format.  It is a "language" which
> describes how to display
> pieces of information (printable characters, images etc) on a page.  It
> consists of a collection
> of instructions to the PDF reader application along the lines of
> "display the characters '12345'
> at position (x,y) on page 3".
>
> It does not retain tabulated data in a tabulated structure.
> Essentially, you are asking how to
> unscramble scrambled eggs or how to extract the butter, flour, eggs and
> milk separately out
> of a baked cake.
>
> However ( ain't there always one of those) - if you are asking about
> Formdata in a PDF, the
> situation is different.  Formdata is where tthe PDF document is
> specifically designed with
> data fields for the users to fill out using an appropriate program. This
> data can be extracted. \
>
> Take a look at A-PDF at http://www.a-pdf.com/form-data-extractor/ or the
> CutePDF SDK at
> http://www.cutepdf.com/solutions/FormSDK2.asp for a couple of tools that
> you could
> integrate with VBA using Shell().  You can use these to extract the data
> to a temporary file
> which you can then import into Access.
>
> -- 
> Stuart
>
>
> On 20 Mar 2010 at 12:32, Edward Zuris wrote:
>
>>
>>  Is there any VBA code available around out
>>  there that can read PDF file data ?
>>
>>  I am sure, I an not the first programmer to
>>  run into this.
>>
>>  Or any ideas that would help.
>>
>>  Many Thanks.
>>
>>  Sincerely,
>>  Edward S. Zuris.
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>