> can anybody please tell me how to convert data to xml?
Not trying to be difficult, but when you say "how" do you mean "What are
the steps necessary to...?" or do you mean "What automated tool(s) do
you recommend to...?" The answer isn't necessarily the same to both
The answer to the first question is fairly straightforward, I think:
(1) Understand your data as completely as possible, particularly how it
is structured (including all the variations on its structure that are
possible). If you can create an outline of a given data store, in the
classic I., A., 1., a., (1), etc. form, then you're well on your way.
(Caveat: When they teach outlining, they tend to say things like "You
can't subdivide a major topic into only one minor -- if you've got an A,
you must have a B" and so on. You don't need to worry about that kind of
(2) Understand that XML is a powerful data format *because* (among other
reasons) it is plain text.
(3) Know or devise some method for saving your data as text while still
preserving its structure.
(4) Use an automated tool to convert the saved-as-text data to its XML
Note that (3) and (4) may be a single step, depending on the
XML-awareness of the environment where the data is currently stored.
E.g., a DBMS may include a "save/export to XML" feature. I'd have to say
that if you're interested in interfacing a DBMS to XML, the one
destination you need to visit first is Ron Bourret's XML and Databases
page. It's at:
John E. Simpson | "For a while I didn't have a car... I
http://www.flixml.org | had a helicopter... no place to park it,
XML Q&A: www.xml.com | so I just tied it to a lamp post and
| left it running. <slow glance upward>"
| (Steven Wright)