Extracting text from XML fields

[rob4465]

Hi - all,

I'm in the middle of converting a database and one of the notes fields has
come across with XML data around the text.

Is there a routine I could use in Access to extract the text I need from the
XML code so I'm just left with the notes text?

I've found a routine here but I've no idea how to implement it into Access:
http://code.activestate.com/recipes/65128/

Thanks in advance for your help.

 

[Tom van Stiphout]

Set a reference to "Microsoft XML, v6.0". If you don't have it listed,
check with the Microsoft Download Center.

Then use this library to parse the XML. The Object Browser can show
you what's available. More details are here:
http://msdn.microsoft.com/en-us/library/ms763742(VS.85).aspx
and in many places on the web.

-Tom.
Microsoft Access MVP

 

[David W. Fenton]

Set a reference to "Microsoft XML, v6.0". If you don't have it
listed, check with the Microsoft Download Center.

Then use this library to parse the XML. The Object Browser can
show you what's available. More details are here:
http://msdn.microsoft.com/en-us/library/ms763742(VS.85).aspx
and in many places on the web.

I just followed your advice and still don't know where somebody
would start with parsing the XML. I thought one of our Access old
hands had written a tutorial on using XML and consuming a web
service, but couldn't recall who it was or where.

Anyone?