I am new to XML and am evaluating Toad for Data Analysis to see if it can help me import XML tables into Access. Currently when I use the Access import, it creates many Access tables out of 1 XML file. Will Toad for Data Analysis help me, and if so, any tips on how to accomplish. Please bear with me, I am fairly overwhelmed with evaluation so many softwares and no success yet. Attached is a sample file that I would like to be able to import into one table in Access. Thank you for any help.
2900-FEDERALTRADECOMMISSION-AWARD.xml (6.42 MB)