Post reply

PDF to SQL Server

  • February 3, 2004 at 4:24 am

    #82153

    Hai,

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

    (either by TSQL or by any programing languages)

     

    thanks

     

  • February 3, 2004 at 4:27 am

    #492591

    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]

  • February 3, 2004 at 4:33 am

    #492594

    i want to read the text only

  • February 3, 2004 at 6:28 am

    #492604

    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]

  • February 3, 2004 at 6:43 am

    #492608

    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.

  • February 3, 2004 at 7:57 am

    #492617

    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

  • February 3, 2004 at 8:07 am

    #492619

    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.

  • February 3, 2004 at 8:38 am

    #492626

    ok thanks

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

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