Exult helps you convert or import data from one or more XML
files into a Microsoft Excel Spreadsheet (XLS
file), a Microsoft Access Database (MDB or
ACCDB file), CSV (comma separated values),
HTML or Text.
The main features:
-
Easy to use: With a familiar wizard interface, converting XML
to Excel, Access, CSV or Text was never this easier!
-
Automatically figures out Table Data: The XML Structure is
processed in an intuitive way to extract table data, and each table is
written to a separate worksheet (or database table), thus simplifying
the task of sorting through the data.
-
Maintains Table Relationships: Table Relationships
(which are dictated by the XML structure) are maintained by
the use of auto-generated primary and foreign keys. Makes it easy to
see how the data in separate tables relate to each other.
-
Merges data from multiple XML files: Merges and extract the
data from multiple XML files. Smart parsing will ensure the data will
be merged according to the XML file structure.
-
Imports Attribute information too when loading XML: Attribute
information within the XML is treated similarly to element information
and is extracted to appropriate worksheets.
-
Select & Convert only the data you are interested in: After
the XML file is loaded, you can preview the data and select the tables
you want to export.
-
Supports multiple export formats: Export data to Microsoft
Excel (XLS), Microsoft Access (MDB or ACCDB), Comma-Separated
Values(CSV), HTML or Text.
-
Extract and Convert data on a schedule: Exult includes a
command line program which makes the task of performing automated
(scheduled) batch conversion of XML easy.
-
Extract your data the way you want it: Exult applies database
normalization rules while parsing the XML file and extracting the data
to an embedded database. The data is distributed to different tables
depending on the structure of your XML. You can merge data in these
these tables with a single click – with proper relationships
maintained.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel
(XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or
ACCDB), or CSV.
Shred and import XML into SQL Server.
Import XML data into automatically created MySQL
tables.