Pdf To database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kirantechno
    New Member
    • Aug 2007
    • 2

    Pdf To database

    I have a pdf file
    it has 12k ppl data
    i need to insert that data into any database (oracle, access, mysql), using VB6.0

    here is the pdf file : http://ceoandhra.nic.in/ERolls/PDF/E...8/A2180001.pdf

    i have been working it... but i could not get the path to do that...

    hope u guys will help me out to.

    thanks in advance
    Last edited by kirantechno; Aug 21 '07, 10:17 AM. Reason: give more info
  • kadghar
    Recognized Expert Top Contributor
    • Apr 2007
    • 1302

    #2
    Originally posted by kirantechno
    I have a pdf file
    it has 12k ppl data
    i need to insert that data into any database (oracle, access, mysql), using VB6.0

    here is the pdf file : http://ceoandhra.nic.in/ERolls/PDF/E...8/A2180001.pdf

    i have been working it... but i could not get the path to do that...

    hope u guys will help me out to.

    thanks in advance
    Im not sure, but i think you cant export information from a pdf with the acrobat reader, you need the acroba editor (or whatever its name is). With that software you're even able to export the data to Excel.

    Anyway, if you find another way, please share it here, because i've had that very same trouble.

    Kad

    Comment

    • kirantechno
      New Member
      • Aug 2007
      • 2

      #3
      Hi kad,
      thanks for response,
      for that I have converted the pdf to txt, (I used the tool pdf to txt from http://www.pdf-to-html-word.com, its free)
      It gives the n no. of txt files depending up on the n no. pages in .pdf file.

      With the help of vba.strings.rep lace, vba.string.spli t functions I made a conforble format for easy data retrieval. Then I placed in a Access .

      Feel free to mail me for more info.
      E-mail address removed by Moderator
      ------> If you know any .ocx which help to convert the pdf to txt let me know that will be great help for me
      Last edited by Killer42; Aug 22 '07, 07:39 AM. Reason: Remove e-mail address as per site guidelines

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Sorry kirantechno, if people want to contact you off-list they'll have to do so by Private Message, or through the send an e-mail" button in your profile. Site guidelines prohibit the posting of e-mail address, your own or anyone else's. This is to prevent them being harvested by scammers and spammers.

        Comment

        • kadghar
          Recognized Expert Top Contributor
          • Apr 2007
          • 1302

          #5
          Originally posted by kirantechno
          Hi kad,
          thanks for response,
          for that I have converted the pdf to txt, (I used the tool pdf to txt from http://www.pdf-to-html-word.com, its free)
          It gives the n no. of txt files depending up on the n no. pages in .pdf file.
          Well that sounds great, thanks.
          I'll check it out.

          Comment

          Working...