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.
| 
data server software 
