Use Access VBA to parse an encapsulated XML file

The source file has a .tpz or .tpzx extension. Examining the file shows that inside it is an xml file named something like [url removed, login to view] that contains the dataset.

Successful bidder will be supplied with 6 sample .tpz or .tpzx files that will be used to confirm the program extracts the data correctly.

I want an access vba application that will allow the user to choose the .tpz file and the program will load the records into a table.

The .tpz file name should be parsed and associated with the answer table.

The file name will have the following naming convention client name - course id - module number - [url removed, login to view]

I want to process the file and store the following elements in tables

the <questiontext>

all the <answertext> associated with the <questiontext>

and the <responsestring> associated with the <questiontext>

The <responsestring> corresponded to the <answertext>

I want to be able to load multiple .tpz files into the database

each file may have matching <questiontext>

I want to be able to report on a percentage basis by <questiontext> by <answertext> with a count of how many <responsestrings> choose an <answertext>

I want to be able to report on a count basis by <questiontext> by <answertext> with a count of how many <responsestrings> choose an <answertext>

Here is an excerpt of the file:

<questions>

<multichoice>

<guid>943EE0884B0F40E0A1152B2DBE5F0154</guid>

<repollguid>6165BDECE86C4CA6B7EFA69FB3F5856C</repollguid>

<sourceid>4805EB2ED0284AB78812A2FE1E993C60</sourceid>

<questiontext>It looks to me like everyone is attentive.</questiontext>

<starttime>5/2/2014 08:51:22 AM</starttime>

<endtime>5/2/2014 08:51:51 AM</endtime>

<showresults>True</showresults>

<responsegrid>0</responsegrid>

<countdowntime>30</countdowntime>

<correctvalue>100</correctvalue>

<incorrectvalue>0</incorrectvalue>

<responselimit>1</responselimit>

<bulletstyle>0</bulletstyle>

<answers>

<answer>

<guid>1D6AFD5AC6744A4A88B18AD3F53895B9</guid>

<answertext>Strongly Agree</answertext>

<valuetype>0</valuetype>

</answer>

<answer>

<guid>CC0B3DBDE4014BAEA958FA17EFA9EC1F</guid>

<answertext>Agree</answertext>

<valuetype>0</valuetype>

</answer>

<answer>

<guid>767926A83C0745A1894BB2C55B82BF59</guid>

<answertext>Neutral</answertext>

<valuetype>0</valuetype>

</answer>

<answer>

<guid>679555962EFA45C1B8DB42A4A9464A20</guid>

<answertext>Disagree</answertext>

<valuetype>0</valuetype>

</answer>

<answer>

<guid>0EBCB08DD91F4B6484DE67571B3E0026</guid>

<answertext>Strongly Disagree</answertext>

<valuetype>0</valuetype>

</answer>

</answers>

<responses>

<response>

<deviceid>1439D4</deviceid>

<elapsed>23591</elapsed>

<responsestring>1</responsestring>

</response>

I have attached a copy of a screen shot showing the XML file inside the TPZ file.
I have re-attached the sample .tpzx file (previous post seems to have disappeared).

The software that generates the .tpz or .tpzx file is called turingpoint and is a product of www.turningtechnologies.com

Microsoft Access Visual Basic para aplicaciones XML

Nº del proyecto: #5968268

Sobre el proyecto