Complete Syntax for converting XML data from the command line

The Exult XML Conversion wizard includes a command-line program which can be used for batch conversion. The command line program companion to the Exult XML Conversion Wizard is called Exultcmd.exe and should be installed in the same directory as Exult.exe.

Click here for some usage examples.

An Overview

  • Convert multiple XML files to MS Access, MS Excel, CSV, Text or HTML.
  • Merge data from multiple XML files and extract to a Microsoft Access Database (MDB or ACCDB), Microsoft Excel spreadsheet (XLS), CSV, HTML or Text.
  • Save data from each table to a different file for CSV and Text output.
  • MS Access compatibility option: Specify -a 2007 to create an Access 2007 database. Also supported are -a 2003 and -a 97 for older versions.
  • Existing output files will NOT be overwritten unless specifically requested (using the -w option).
  • Supports a dry-run option (using the -n option) where no actions are performed but the files that will be processed and the output that will be created are shown.

Complete Usage Syntax

The formal usage syntax is given below.
The -t Type option is required to specify the type of output. Also, more than one input file or pattern can be specified.
  Exultcmd.exe [Options] -t <Type> InputFile(s)
The following are the valid output types supported for use with the -t option.
-t MDB
Convert XML to a Microsoft Access Database (MDB or ACCDB)
-t XLS
Convert XML to Microsoft Excel Spreadsheet (XLS)
-t CSV
Convert XML to Comma Separated Values (CSV) file
-t HTML
Convert XML to HTML
-t TEXT
Convert XML to delimited text file. Specify the delimiter using the -s option.
The following options are supported.
-a AccessVersion
Specify the version of Microsoft Access in which the saved output is to be opened. Applicable only when saving to a Microsoft Access Database (-t MDB). Default is to save in an Access 97 compatible format.
-a 2007
Save output in a Microsoft Access 2007 compatible format.
-a 2003
Save output in a Microsoft Access 2003 compatible format.
-a 97
Save output in a Microsoft Access 97 compatible format.
-d OutputDir
Create output file(s) in the specified OutputDir. Supported only for CSV or TEXT output. When this option is specified, data from each table is written to a separate file in the specified directory.
-f OutputFile
Write output to the specified file. Note that only one of -f or -d option can be used.
-n
Dry-run option. Shows the input files that will be processed and the output files that will be created without actually doing anything.
-q
Turns on quiet mode which suppresses progress reporting. Use this option when processing large files since progress reporting slows down the program a little bit.
-s SeparatorChar
Used with -t TEXT output type. Specify the field delimiter character to be used (typically ",", ":", etc).
-w
Overwrite output file(s) as needed. Existing files will NOT be overwritten unless this option is used.

Click here for some usage examples.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.