I have an Access 2003 table with an XML field that is tagged as follows:
<Calendar CompactMode="1"><CustomProperties><CustomProperty Name="startdate" Value="3/26/2007" VariantType="8"/><CustomProperty Name="recurrencestarttime" Value="10:00:00 AM" VariantType="8"/><CustomProperty Name="membername" Value="John Smith" VariantType="8"/><CustomProperty Name="starttime" Value="10:00:00 AM" VariantType="8"/><CustomProperty Name="comment" Value="" VariantType="8"/><CustomProperty Name="casemanagerid" Value="250" VariantType="8"/><CustomProperty Name="districtid" Value="" VariantType="8"/><CustomProperty Name="riderequestid" Value="288" VariantType="8"/><CustomProperty Name="endtime" Value="12:00:00 PM" VariantType="8"/><CustomProperty Name="archived" Value="Open" VariantType="8"/><CustomProperty Name="recurrenceendtime" Value="10:30:00" VariantType="7"/></CustomProperties></Calendar>
I need to extract the text from each of the CustomProperty Name fields. For example, I need to extract the actual MemberName value of John Smith from <CustomProperty Name="membername" Value="John Smith" VariantType="8"/>.
I'm using Access 2003 with Windows XP. Many thanks in advance to anyone who can point me in the right direction.