Import from Databases, Text Files, and Microsoft Excel Sheets
oXygen offers you support for importing database data, MS Excel files and text files
into XML documents, that can be further converted into other formats using the Transform
You can examine the database contents and select the table to be exported using the
database browser. It is possible to refine the data source by editing the generated SQL
select statement to suit your needs. You can join multiple tables or use advanced SQL
expressions. You also have the possibility to generate an XML Schema from the database
Mapping of the database fields as elements or attributes is very simple and you can
change easily the names used in the XML file. A preview of the first rows in the SQL
result and of the generated XML document is available. If the preview shows what is
expected, you can choose to open the imported data directly into the editor and/or to
save it to a file.
You have the possibility of importing data from Excel and text documents.
The Import dialog box allows you to choose what sheets of the document you want to
import. This dialog also displays the content of an Excel document in a tabular form, a
preview of the generated XML document and provides options that allow you to customize