Load XML to ADODataset

take a look at this PAQ:
https://www.experts-exchange.com/questions/21586387/Is-there-any-way-to-export-record-in-xml-from-ado.html
you might need to save the xml file from an adodataset first to see exactly the formatting before loading (just to make sure you follow the same formatting rules)

This data cannot be transformed as is. More information is needed

My XMLTable control will not save back to the table, only create the
XML file from the dataset results and it uses a standard format. The
default format is the same as Oracle 8 used for importing.

If you have a schema for your ADODataset that you can show and how the XML data corresponds,
I'm sure someone may write a parser for you.

It looks like this (column name, data type, max length):
type, string, 2
value, string, 50
align, string, 1
face, string, 30
size, string, 2
style, string, 1
voffset, string, 5
mroffset, string, 5
break, string, 1

The problem is, that I need to keep the XML file as easiest to edit as possible. Or if you could suggest some other XML format (I don't know very much about XML). I could write my own parser for this specific format, but than I'll have to modify it every time a change occurs.

Ok, give me a little while and I'll write a parsing routine for you.

I forgot to mention that the Memo on the form has the XML text.

Oh, and you can remove the persistant fields from ADOTale1, too.

Thanks for the parser, it works perfectly.

PS: Why do you have to remove #13 and #10?

You don't want the extra whitespace in the XML when parsing.