After poking the bear and touring the internet I finally understand why people always said storing pictures in Access is bad, it is because they are invariably put in by bound controls or directly into the tables via native Access UI which means an entire Ole Package wrapper around the file making them difficult to do anything constructive with as opposed to an actual binary stream that can be easily read out to a file and be used in a rational manner.
However embedded Ole wrapper packages is what I have and I am hoping there is some easy way to consume the entire package in Excel.
Can I take an embedded Ole object that is a picture and write it into some sort of control in Excel and have it display the picture - preferably from a recordset?
I am using Office 2013.
A less favorable prospect would be to open the picture for each record, save it and then use files directly - I can find using files but did not pay much attention as best I can tell no way to save files. I am assuming the saving would have to be manual but if there is code / automation I would welcome it. Currently I have Win 7 and paint... obviously OS upgrade is coming in the not too distance future thanks to the end of update support for Win 7 - betting I have 3 to 6 months left on it.
The closest thing to useful I found is the below but that is going the wrong way. I have not played with bound ole objects. I guess that is next on my search for the kitchen sink.
However embedded Ole wrapper packages is what I have and I am hoping there is some easy way to consume the entire package in Excel.
Can I take an embedded Ole object that is a picture and write it into some sort of control in Excel and have it display the picture - preferably from a recordset?
I am using Office 2013.
A less favorable prospect would be to open the picture for each record, save it and then use files directly - I can find using files but did not pay much attention as best I can tell no way to save files. I am assuming the saving would have to be manual but if there is code / automation I would welcome it. Currently I have Win 7 and paint... obviously OS upgrade is coming in the not too distance future thanks to the end of update support for Win 7 - betting I have 3 to 6 months left on it.
The closest thing to useful I found is the below but that is going the wrong way. I have not played with bound ole objects. I guess that is next on my search for the kitchen sink.