Results 1 to 2 of 2
  1. #1
    rob4465 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    4

    Extracting text from XML data

    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.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    text string manipulation is an interesting art & skill; what you want to research in the VB Help area or in a text book or online is the TRIM methods; i.e. Left Right Mid and InStr

    one can implement it in a query using a calculated field or one can implement in a vb routine. you indicate that you are a novice and it really isn't novice stuff but it is very do-able...would be difficult to explain every possibility via a forum....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Extracting data after a keyword
    By KerryA in forum Queries
    Replies: 1
    Last Post: 02-11-2010, 09:56 PM
  2. Extracting data from a disastrous excel-style Table
    By milehighfreak in forum Import/Export Data
    Replies: 2
    Last Post: 12-16-2009, 07:13 AM
  3. Data from text file
    By Directlinq in forum Programming
    Replies: 1
    Last Post: 10-19-2009, 02:29 AM
  4. Replies: 1
    Last Post: 07-10-2009, 07:25 AM
  5. Extracting Database Schema From Access
    By ChloeRadshaw in forum Access
    Replies: 0
    Last Post: 01-29-2009, 04:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums