Solved

Is it possible to read the text of a PDF file into Access 2007 using VBA? If so, how?

Posted on 2009-04-09
6
549 Views
Last Modified: 2013-11-27
As a result of help with a previous related question "How can I read text documents (e.g. Word 2007 and PDF) into Access 2007 using VBA?" I can now import the text of single .txt files and .doc and .docx Word documents to Access using VBA. I am now very interested to learn if there is any way a PDF file (or several PDF files) can be read into a VBA Varable or Access 2007 table automatically. I would be very grateful for any help on this...
0
Comment
Question by:DataTrain
  • 4
6 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 200 total points
ID: 24106647
I don't know much about this but I'm pretty sure you are going to need some third party software to read from pdf files.  Adobe produce a SDK for developers to extract text from docs created using theire pdf writer and other companies produce tools (for sale) to convert pdfs to text.
0
 

Accepted Solution

by:
DataTrain earned 0 total points
ID: 24107337
That is helpful. I have emailed Adobe with a question about this. Does anyone else have experience of interection with text from PDF files under software control??
0
 

Author Comment

by:DataTrain
ID: 24108683
Adobe say I just need Adobe Reader 9 which I already have installed. I can't figure out how this helps me. Do I need to select a Library from Tools/References - if so I can't see anything that looks right. Beyond that what VBA commands do I use. I have contacted Adobe again through their support site but would still value any other input or ideas.........???
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 50 total points
ID: 24115449
Just a side note here.

The maximum amount of charachters allowed in an Access field is 65,000 (Memo), many PDF files exceed this limit.

JeffCoachman
0
 

Author Comment

by:DataTrain
ID: 24116608
That may not matter as I am most interested in the first page or so. I just don't know how or if it is possible!!
0
 

Author Comment

by:DataTrain
ID: 24117003
I don't think this is getting anywhere. The best I can think of is to use a PDF to Word converter and then import the text from Word. The converter I found is:

http://www.soliddocuments.com/products.htm?product=SolidConverterPDF

If anyone knows a method of directly importing the text of a PDF into Access VBA please let me know!
I will close this now. Thanks for the suggestions
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) is among the most important applications that I run on my Windows computers. I use it every day, for nearly all of my document and photo scanning, as well as most of my…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question