Shred & import multiple XML files into an SQL Server database.
Exult SQL Server allows you to easily shred and import multiple XML files into an SQL Server database. Tables and columns are automatically created in SQL Server depending on the structure of the XML. Data from multiple XML files are merged appropriately into the correct tables. The procedure for importing multiple XML files into SQL Server is essentially similar to importing a single XML file.
For this example we will use a publicly available XML data set: U.S. House of Representatives Roll Call Votes, 112th Congress - 1st Session (2011), available here in XML format. We have selected 100 roll call vote data: 1 through 99.
And that is how easy it is to shred and import multiple XML files into SQL Server.
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.