All,
I have been given 225 XML files of "questions" and no Schema, and
have been asked to load the data from the XML files into an existing
Access DB.
Each file is essentially 1-n questions and their answers, e.g:
- <Answer name="ClientAddressCityTXT">
<TextValue>Philadelphia</TextValue>
When I import the XML into Access using Get External Data | Import, I
get 3 tables of data - yes/no answers, MC answers, and a blank
Rptvalue table. Interestingly, the TextValue answers don't make it.
Since I "understand" the data in the XML file, I know there's a long
way I can corral the data by bringing it data into Excel, shifting it
around as needed, and then moving it into Access.
But there has to be a faster way...
I've tried a couple of XML tools, but they all ask me for my schema,
which I don't have....
Any suggestions on an easier way to do what I need to do?
Is there a tool to create a schema from an XML file? Would that even
help me?
Thanks,
Patrick