?
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
Medium Priority
?
575 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 800 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 200 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Suggested Courses

612 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