Results 1 to 4 of 4
  1. #1
    gumbi17's Avatar
    gumbi17 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Houston, Tx
    Posts
    19

    Export image as image

    I was handed down a database that is connected to a sql server, and the database had an OLE field for attaching a pdf. Well flash forward a hundred years and now I need to export all of those images out of the sql server. They are set as images in their table (dbo.lease_basic), I need to export their lease number (LeaseNum1) and the image (inst_copy) out into either an excel document that allows those .pdf's to open or something else. Can anyone help.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    build a report that has the image on the report.
    then output it to PDF....

    docmd.OutputTo acOutputReport ,"rptMyReport",acFormatPDF,"c:\folder\file.pdf"

  3. #3
    gumbi17's Avatar
    gumbi17 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Houston, Tx
    Posts
    19
    There are about 4000 records attached!

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I am going to guess that you will need to deal with the OLE wrapper in order to extract the actual file. I have done something similar before. Not sure where my examples are.

    I found this, though. Something like the WriteBLOB() function is what you want. There may be a tool that does something similar. I can't remember. Also the constants used for the function may need to be scrutinized.
    https://support.microsoft.com/en-us/kb/103257

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-13-2015, 12:07 PM
  2. Bitmap image won't export to excel?
    By C6067 in forum Import/Export Data
    Replies: 2
    Last Post: 03-04-2013, 03:31 PM
  3. XML Export OLEObject/Image Data Structure
    By duckwilliamson in forum Import/Export Data
    Replies: 0
    Last Post: 10-11-2012, 07:45 PM
  4. Replies: 2
    Last Post: 10-10-2011, 10:58 AM
  5. Image help?
    By ndynamo in forum Reports
    Replies: 1
    Last Post: 01-12-2011, 04:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums