3.1 How to import XML into SQL Server from the command line

The following examples describe how to import XML into SQL Server from the command line.

For the syntax of DBString, click here.

To use SQL Server Authentication, specify a user name and password for connecting to SQL Server.

  1. Import a single XML file into SQL Server

    Exultcmd.exe DBString C:\Path\To\File.xml

  2. Import multiple XML files into SQL Server

    Data from the XML files are merged according to the XPath and imported into SQL Server.

    Exultcmd.exe DBString C:\Path\To\File_1.xml C:\Path\To\File_2.xml

  3. Import a bunch of XML files

    Exultcmd.exe DBString C:\Path\To\*.xml

  4. Import a bunch of XML files in different directories

    Exultcmd.exe DBString C:\Path_1\To\*.xml C:\Path_2\To\*.xml ..

  5. Import data from a HTTP URL

    Exultcmd.exe DBString http://www.example.com/Path/To/File.xml

  6. Specify username and password for use with HTTP Authentication

    Exultcmd.exe DBString http://user@passwd:www.example.com/Path/To/File.xml

  7. Import data from an FTP URL using Anonymous FTP

    Exultcmd.exe DBString ftp://ftp.example.com/Path/To/File.xml

  8. Specify user name and password for retrieving a file with FTP

    Exultcmd.exe DBString ftp://user@passwd:ftp.example.com/Path/To/File.xml

  9. Specify a different port number in a HTTP URL

    Exultcmd.exe DBString http://www.example.com:8080/Path/To/File.xml

  10. Specify a different port number in a FTP URL

    Exultcmd.exe DBString ftp://ftp.example.com:2121/Path/To/File.xml

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.