Export Images to XML

[Meagon]

Hi,

I'm a newbie and i was asked if i could find a way to export images on a long binary data type field of a table to xml.
I'm using : ExportXML acExportTable, "Table1", "c:\tb1.xml"
After the export i can't seem to import them back from the tb1.xml file...
Anyone had/has this experience?
I'm :banghead: and : pray2: for a way out...

:help !

Thkx,

Rod

[stanl]

You could use the ADO Recordset's .save method and persist as XML in which case all binary data is converted to binhex; or you could take the long way and output to an ADO Stream then perform a binhex64 conversion.
.02
Stan

[Meagon]

I think i get your point, but how exactly do i do it? :dunno

[stanl]

This will give you a conceptual overview of the 2nd method I suggested.

http://www.eggheadcafe.com/articles/20010824.asp

If you can post a sample of your Access binary data [1-2 rows], I can drop a procedure in to illustrate the first method.

[Meagon]

I have an ID and a MyBlob row.
I use the ID as a Foreign Key on another table.

(was this the info you needed?)


Big thanks on the link!

[stanl]

I'm assuming when you used the word Image you meant that your binary field holds jpgs/bmps. Then the bigger question becomes how were they inserted? I have to attend funeral services but I'll try to post a jpeg example.