Extracting OLE Image from Microsoft Access Field

In this Microsoft Access tutorial, I will show you how to extract an OLE image from a field to convert and save your embedded pictures as JPEG or BMP files using VBA, even when facing the 'format not supported' error.

David from Queensland, Australia (a Silver Member) asks: I've been following your YouTube tutorials and learned that storing images directly in a database isn't efficient. As a coin collector, I've accumulated over 2,000 images in my database. I tried to extract these images into .jpg or .bmp formats using a VBA script, however, I can't view the images produced by the script; they appear to be the correct size but the format isn't supported when I attempt to open them. Could you advise on how to fix this issue to avoid manually saving each image?

Prerequisites

• Intro to VBA
• SendKeys
• Sleep
• Delete Files

Links

• Images
• Snip & Sketch

Recommended Courses

• Access Developer Courses

Up Next...

• Extract OLE Image, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, extract OLE images, save images Access database, VBA script image extraction, Access database VBA, OLE object field, JPEG BMP conversion, extract OLE objects VBA, Microsoft Access tutorial, OLE field images, converting OLE to JPG, extract images OLE object field, VBA code image extraction