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.

Connection and Table Selection Dialog

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.

The Import Dialog

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.

Fields Map Dialog

You have the possibility of importing data from Excel and text documents.

Import Excel File

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 the output.