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 features.

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 structure.

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 an Excel Sheet and text files. The import dialog is similar to the one used for databases, the sheet being the correspondent of a table and the columns linked to the sheet or text file columns.