XML field conversion

[rob4465]

Hi all -

I'm in the process of doing a database conversion - one of the fields in the database I'm converting from contains some entries in a XML format 'basically a notes field'. If I extract one of these entries and save it as a .xml file I can open it and read it with Word.

So I now have a field called Notes in a Access 2007 db that contains these note entries - lots of notes surrounded by xml code.

Is there any VBA module or update query that I could run against this notes field to strip out the xml tags? or is there a way to somehow parse this xml data so access can translate it?

Thanks in advance for your help !

 

[gemma-the-husky]

I think you will have to do it manually with the MSXML library

MS Help is here

http://msdn.microsoft.com/en-us/library/ms763742(VS.85).aspx

but its tricky for a start.