Use SSRS to Extract Data from PDF

Posted on 2011-10-13
Last Modified: 2012-05-12

Is there a way I can extract data in a PDF file?  I have several PDF files from which data need to extracted into a SQL Server.


Question by:thomaszhwang
    LVL 11

    Accepted Solution

    A number of applications are available to convert pdf to excel, and many are free downloads. Try googling "pdf to excel conversion tools." I've tested quite a few, and they work reasonably well. The catch is that the pdf has to have a table-like structure, otherwise it's hit and miss.

    To my knowledge, there are no tools to convert directly from pdf to SQL, so you would need to use the middle step of converting to excel first.

    Author Closing Comment

    LVL 11

    Expert Comment

    by:Simone B
    Hey, thanks very much. I hope you were able to find something that worked for you.


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 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

    14 Experts available now in Live!

    Get 1:1 Help Now