This HOWTO demonstrates how to easily convert XML to Microsoft Access using the Exult XML Conversion Wizard.
To demonstrate how to convert XML to Access, we will use the publicly available information about everybody who has served in the US Congress ( House of Representatives and US Senate), available here: people.xml.
This screen shows the progress of parsing the XML file. For a large file, the processing could take some time. Exult has been specially optimized for converting large XML files without running into memory limitations. This is accomplished by processing parts of the XML file without loading it entirely into memory.
To stop the processing at any time, click the Cancel button. Once the processing is complete, click Next.
We can now preview the imported XML data. The top panel shows the data tables identified from the XML and the bottom panel shows the data for the selected table. The table hierarchy shown in the top panel is derived from the nesting of XML tags and is built in a natural, easy-to-understand way.
Each table shown in the top panel also shows the number of rows in the table. For this example, we can see that 12489 rows were found for the US Congress people. A sample cross-section of the data is shown below for each of the major tables: PEOPLE and ROLE. Once you are done previewing the data, select the tables required to be exported to Access and click Next.
That was a short and easy task converting XML to Access using the Exult XML Conversion Wizard. You can now download a free trial and check it out for yourself.
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.