Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Unanswered: Lookup a pdf file from within Access

    Using MS Access and a pdf or html or xml file, I want to be able to use the records in Access client table to see if the client name exist in the pdf or html or xml file.

    Is that possible?

    Regards

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    I've done something similar with a .html and .xml file before but I'm not sure about .pdf.

    I opened the file and read through it a line at a time at searched the string as I went.

    From memory it was something like this:

    fname = "C;\path\"mttextfile.txt Close 'closes file if stuck open
    Open fname For Input Access Read As FreeFile
    Do While Not EOF(1)
    Line Input #1, textline
    If Instr (1, textline, "the") > 0 Then
    ...do something here....
    end if
    Loop
    Close
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    implicitly you can do the same sort of thing with a PDF providing that the information you want is correctly identified in the PDF stream.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •