Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unhappy Unanswered: HELP - Need to Extract PDF files from Access Table

    Someone gave me an Access table with 1000 PDF files embedded in OLE object fields. I know I have to do some tricky programming here, but the Access help files are of no use.
    Can anyone tell me where to begin to extract these files out to a directory?

    Thanks - PacketMule
    Last edited by PacketMule; 03-23-04 at 12:27.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: HELP - Need to Extract PDF files from Access Table

    Originally posted by PacketMule
    Someone gave me an Access table with 1000 PDF files embedded in OLE object fields. I know I have to do some tricky programming here, but the Access help files are of no use.
    Can anyone tell me where to begin to extract these files out to a directory?

    Thanks - PacketMule
    Found it. Check out this MS Knowledgebase link: http://support.microsoft.com/default...roduct=acc2000

  3. #3
    Join Date
    Jul 2003
    Posts
    3

    Re: HELP - Need to Extract PDF files from Access Table

    I have tried the technique MS posted.
    Using Microsoft's instructions for Writing Blobs I succeeded in bringing
    down what was in the OLE fields.
    2 Problems: First, I don't have a seperate field that
    holds the filename (that has to be extracted from the OLE
    field information somehow), and second, the file is
    unusable because Adobe says, "...it is not supported or
    has been corrupted...".
    I'm assuming that there has to be some sort of filter I
    have to push the binary data through to have it come out
    as a PDF.
    Otherwise, more in-depth coding will be involved.
    So much for ease of use.

    Where to now?
    Thanks.

  4. #4
    Join Date
    Jul 2003
    Posts
    3
    Thanks for the help.
    After someone pointed an idea out, the answer was simple.
    No massive coding rage, a dozen lines of code.
    Working in the FileSystemObject Method was all it took.
    Thanks.

Posting Permissions

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