[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