Question about exporting MS Access table to XML?

Question

Microsoft Access

The table stores jpg-files; when exporting to XML, these images are converted to base64 format.

Take for example this picture


. Its export code looks like this:

FRw7AAIAAAAfAAgAFAAzAP/////O4frl6vIg8+/g6u7i+ejq4CDk6/8g7uHu6+73<br>
6ugAUGFja2FnZQABBQAAAgAAAAgAAABQYWNrYWdlAAAAAAAAAAAA9gEAAAIAZmF2<br>
aWNvbi5wbmcAQzpcVXNlcnNcQW5cRGVza3RvcFxmYXZpY29uLnBuZwAAAAMAKwAA<br>
AEM6XFVzZXJzXEFuXEFwcERhdGFcTG9jYWxcVGVtcFxmYXZpY29uLnBuZwDdAAAA<br>
iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAIAAAD8GO2jAAAACXBIWXMAAC4jAAAu<br>
IwF4pT92AAAAj0lEQVR42mOoW7CBpohh1IKRbcF/VECkVDWtLaiav37UAvxSNI/k<br>
QWwBHjBqARx8+/kLSP76/effv39D0Ad0Tabvv3ylrQUfvn6jtQ9wWlBNlbLo+69f<br>
tLbgJ/kWVMxdR1GNRtCCqnlQFQ2LNjUs2dwIQpsaFm+qQVID5AIFgVJABWjay+et<br>
G222jFpAXQQAIPIwWJVw/PIAAAAASUVORK5CYIIqAAAAQwA6AFwAVQBzAGUAcgBz<br>
AFwAQQBuAFwAQQBwAHAARABhAHQAYQBcAEwAbwBjAGEAbABcAFQAZQBtAHAAXABm<br>
AGEAdgBpAGMAbwBuAC4AcABuAGcACwAAAGYAYQB2AGkAYwBvAG4ALgBwAG4AZwAf<br>
AAAAQwA6AFwAVQBzAGUAcgBzAFwAQQBuAFwARABlAHMAawB0AG8AcABcAGYAYQB2<br>
AGkAYwBvAG4ALgBwAG4AZwABBQAAAAAAAMOtBf4=<br>

And if you use the www.motobit.com/util/base64-decoder-encoder.asp service , the code turns out like this:

iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAIAAAD8GO2jAAAACXBIWXMAAC4jAAAuIwF4pT92AAAA<br>
j0lEQVR42mOoW7CBpohh1IKRbcF/VECkVDWtLaiav37UAvxSNI/kQWwBHjBqARx8+/kLSP76/eff<br>
v39D0Ad0Tabvv3ylrQUfvn6jtQ9wWlBNlbLo+69ftLbgJ/kWVMxdR1GNRtCCqnlQFQ2LNjUs2dwI<br>
QpsaFm+qQVID5AIFgVJABWjay+etG222jFpAXQQAIPIwWJVw/PIAAAAASUVORK5CYII=<br>

Moreover, during reverse decryption, the code received from Access does not turn into a picture.

Further, the XML file will be processed by means of PHP.

How can this be fixed? Is it possible to force Access to do the correct base64, or is there some way to get this picture from its weird code?

Answer 1

Take a closer look at what the access gave you - throw out the first four lines and voila, you will get what the service gives out.
The point is that your ole field stores data about the built-in object, and then the object itself.
well, base64 itself is correct

Answer 2

It looks like you'll need to
use the GDI+ lib from MS (included in standard Win) to import and export images to/from Access OLE
If I understand the problem correctly, the first answer from here might nudge you in the right direction
stackoverflow.com/questions/114326/converting -ms-access-ole-objects-back-to-plain-jpegs-best-way
then this might solve the problem