{"id":2148,"date":"2025-03-25T17:32:05","date_gmt":"2025-03-25T09:32:05","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=2148"},"modified":"2025-03-25T17:32:05","modified_gmt":"2025-03-25T09:32:05","slug":"extracting-ole-thumbnails-using-access-ole-export-sql-blob-export","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-access-ole-export-sql-blob-export\/","title":{"rendered":"Extracting OLE thumbnails using Access OLE Export \/ SQL Blob Export"},"content":{"rendered":"<p><a href=\"https:\/\/www.yohz.com\/aole_details.htm\">Access OLE Export<\/a> \/ <a href=\"https:\/\/www.yohz.com\/sbe_details.htm\">SQL Blob Export<\/a> version 7.9 onwards has an option to extract OLE thumbnails from OLE-Object fields.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2149\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail03.png\" alt=\"\" width=\"569\" height=\"185\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail03.png 569w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail03-300x98.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/p>\n<p>There are a couple of situations where this is useful.<\/p>\n<ol>\n<li>A linked OLE-Object image file may no longer be available, but a thumbnail was stored.\u00a0 You can now at least extract the thumbnail.<\/li>\n<li>You only need the image and not the entire file.\u00a0 For example, you may only need the thumbnail images from an Origin project files.\u00a0 Exporting the thumbnails gives us the image, without needing to first export the project file, open it, then save the image to disk.<\/li>\n<\/ol>\n<p>Download the latest version of <a href=\"https:\/\/www.yohz.com\/downloads\/accessoleexport\/AccessOLEExportSetup.zip\">Access OLE Export<\/a> \/ <a href=\"https:\/\/www.yohz.com\/downloads\/sqlblobexport\/SQLBlobExportSetup.zip\">SQL Blob Export<\/a> and experience how you can easily export OLE thumbnails.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-access-ole-export-sql-blob-export\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-access-ole-export-sql-blob-export\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Access OLE Export \/ SQL Blob Export version 7.9 onwards has an option to extract OLE thumbnails from OLE-Object fields. There are a couple of situations where this is useful. A linked OLE-Object image file may no longer be available, but a thumbnail was stored.\u00a0 You can now at least extract the thumbnail. You only [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[17,44],"tags":[18,224,223,48],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2148"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=2148"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2148\/revisions"}],"predecessor-version":[{"id":2150,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2148\/revisions\/2150"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=2148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=2148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=2148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}