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
557 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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.

 
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

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.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

707 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