[AccessD] PDF into Access

Stuart McLachlan stuart at lexacorp.com.pg
Sat Mar 20 16:54:54 CDT 2010


Bottom line - PDF is just not a suitable format for sharing of structured data.  
 
Unless you can get the people sending the data to use an appropriate file type, you will 
always have problems extractng the data consistently.

-- 
Stuart

On 20 Mar 2010 at 12:19, Edward Zuris wrote:

> 
>  The data is sent to me in PDF form.
> 
>  So, I am kind of stuck.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Saturday, March 20, 2010 10:32 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] PDF into Access
> 
>  Hi Edward:
> 
>  I have only managed PDF files as far as
>  translating reports to PDF files and reading
>  PDF files while in Access. The translating
>  of PDF files to text is something I have 
>  avoided because like you I have found out
>  the results are not always consistent. 
>  Unless you are up to building a really 
>  complex parser or have a very static data
>  layout it is going to be real difficult.
> 
>  Why not work with vanilla spreadsheet CSV type files? 
> 
>  Jim
> 
>   
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward Zuris
> Sent: Saturday, March 20, 2010 9:16 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] PDF into Access
> 
> 
>  Hi Jim,
> 
>  I think I am missing something here.
> 
>  The PDF reader can make a text file, but if the
>  data is columns and rows of dates where every so
>  often a  column will be missing a date, the text
>  will shift the next date to the left.  Thus after
>  awhile you can't tell which date belongs to
>  which column.
> 
>  Are we talking about two different things ?
> 
>  Thanks.
> 
>  Edward. . . .
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Friday, March 19, 2010 4:50 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] PDF into Access
> 
> 
>  Hi Edward:
> 
>  There is Adobe PDF reader... Just select a file with
>  the appropriate extension 'pdf' and your are good to
>  go... no add-ins or nothing. That can be easily done
>  in code. One line I believe; DOCMD....
> 
>  If you are talking about creating PDF files through
>  Access, that is also fairly straight forward but does
>  require a bit more code and a free third
>  party app: PDFCreator.
> 
>  Jim
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward Zuris
> Sent: Friday, March 19, 2010 3:46 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] PDF into Access
> 
> 
>  Hi Drew,
> 
>  I have office 2000.  
> 
>  And access to a computer with access 2003.
> 
>  Is there any ADD-IN that can be used with
>  PDF files ?
> 
>  Thanks.
> 
>  Ed.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
> Sent: Friday, March 19, 2010 1:02 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] PDF into Access
> 
> 
> With Office 2003, you have a Microsoft Document Printer (or something
> along those lines, you have to have all the features/tools installed for
> Office 2003).  Printing to that printer, will create a file that will
> open in another Office tool that has OCR capabilities.
> 
> Drew
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward Zuris
> Sent: Friday, March 19, 2010 2:17 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] PDF into Access
> 
>  
>  Any suggestions on how to import PDF files/data
>  in to Access 2000 and 2003 ?
>  
>  Thanks.
>  
>  Sincerely,
>  Ed Zuris.
>  
>  
>  
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> The information contained in this transmission is intended only for the
> person or entity 
> to which it is addressed and may contain II-VI Proprietary and/or II-VI
> Business 
> Sensitive material. If you are not the intended recipient, please
> contact the sender 
> immediately and destroy the material in its entirety, whether electronic
> or hard copy. 
> You are notified that any review, retransmission, copying, disclosure,
> dissemination, 
> or other use of, or taking of any action in reliance upon this
> information by persons 
> or entities other than the intended recipient is prohibited.
> 
> 
> -- 
> 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
> 
> -- 
> 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





More information about the AccessD mailing list