Parse XML field stored in a linked table

  • Thread starter Timothy via AccessMonster.com
  • Start date
T

Timothy via AccessMonster.com

I am using Access 2003 with linked tables from a SQL Server. As it turns out,
one of the tables has a field that has XML data stored in it (memo data type).
I need to be able to display the data from that field in a non-XML format. I
see that Access has some functionality that should be able to do this, it
looks like wih VBA and MSXML-Document Object Model, but I haven't been
successful with any of the suggestions from what I thought were similar posts.
I was hoping someone could point me in the right direction.

Thanks in advance

Tim
 
Top