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
542 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 50 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In a previously published article (http://www.experts-exchange.com/articles/10331/Automatic-Duplex-Scanning-in-PaperPort-Versions-11-12-14.html) here at Experts Exchange, I explained how to achieve duplex (double-sided) scanning in Nuance's PaperPor…
This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now