Jim Lawrence
accessd at shaw.ca
Sat Mar 20 12:31:53 CDT 2010
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