PDF to SQL Server

  • Hai,

    Is it possible to take texts from a PDF file to SQL server ?

    (either by TSQL or by any programing languages)

     

    thanks

     

  • Do you want to store the whole file or just the text?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • i want to read the text only

  • Now, if you want to read the text, you can only do this when you have stored only the text.

    When you have stored the file and want to read the text, I guess that won't work as you need to retrieve the file to read the text.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • What I do

    1. Use Acrobat (min v5) to save the PDF in RTF format

    2. Use Word op open RTF file

    3. Copy text and store in database

    I do 1 manually and use an app to do 2 & 3.

    Be warned the process is not 100% accurate, you do not get all the formatting but you should get the text

    Far away is close at hand in the images of elsewhere.
    Anon.

  • OK, thankls

    Actually my aim is to provide a search facility for our Web Server.

    Microsoft Index Server and ASP Search is not meeting our requirement. so i thought of taking all the file content to database so that i can do anything.

    Any suggestion  Frank , David

     

    Thanks & Regards Gvd

  • quoteActually my aim is to provide a search facility for our Web Server.

    That is why I do it. I use Full Text search to seach column in db and use ref in row to point to PDF that is external to db.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • ok thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply