Specify an XML file to import into SQL Server by just listing it out on the command line:
Exultcmd.exe Host@dbName C:\Path\To\file.xml
Want to import multiple XML files into the database? Just list out all of them.
Exultcmd.exe Host@dbName C:\Path\To\fileA.xml
C:\Path\To\fileB.xml
Listing out each file like shown above gets boring after some time. Use a wildcard to specify files matching a pattern.
Exultcmd.exe Host@dbName C:\Path\To\file*.xml
Here is how you can convert all XML files in a directory:
Exultcmd.exe Host@dbName C:\Path\To\*.xml
Need to import XML files in multiple directories?
Exultcmd.exe Host@dbName C:\Dir\A\*.xml C:\Dir\B\*.xml
3.3.3.1 Specifying URLs |
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.
Import XML data into automatically created MySQL tables.