Convert to XML

Date: Feb. 10, 2004
Link: http://rustemsoft.com/XMLScenario.htm
Source Author or Organization: RustemSoft

In order to present your data (Excel file, Access database etc.) to the user in an attractive way in browser, mobile phone or PDF format, the original data must first be converted to the necessary XML formats. XML documents and data can be available in almost any structure whatsoever. Everyone can define his or her own XML document structure and describe it. However, a standard database table (Excel spreadsheet, Oracle table/view) is a plane, two-dimensional representation of data content. When you convert your data source table to XML format you get a plane column-row shaped XML output. This brief article is intended to help people around the world. What to do if you need to get an especially structured XML file from your Excel source (or from other data storage)? How to create an XML with your particular multi-level tagged tree structure from your specially formatted data source?