Re: Import certain elements from XML into Access

Patrick Halstead — Fri, 22 Dec 2006 07:32:09 GMT

Hi Dave and welcome!
I like your signature. :) We are pretty Noob with regards to Access. This seems like more of an XML traversal question an anything else. You'll need to select the node. There should be something like SelectSingleNode for VB. I forget but it's probably in my book on Developing Solutions with InfoPath. Sorry but the childnodes will traverse everything. You'll have to specify an xpath to filter the values.

Import certain elements from XML into Access

davers — Tue, 19 Dec 2006 17:19:09 GMT

Hi everyone. I'd like to import only certain XML elements from the InfoPath form into Access. I quite the newbie when it comes to InfoPath and XML...but here is what I have so far:


Sub TestXML()

Dim objDoc As MSXML2.DOMDocument40
Dim objNode As MSXML2.IXMLDOMNode
Dim nodeList As MSXML2.IXMLDOMNodeList
    
Set objDoc = New MSXML2.DOMDocument40
Set nodeList = objDoc.childNodes
    
objDoc.Load xmlSource:="C:\Documents and Settings\dmorri18\Desktop\Form1.xml"
        
For Each objNode In nodeList

' 1 = element and 7 = processing instruction
    If objNode.nodeType = 1 Then
        Debug.Print objNode.nodeTypedValue
    End If
    
Next objNode
            
End Sub

The problem is it just prints the data in one long line. I'd like to only print out 3 of the 5 values. Does anyone know how to choose which ChildNodes I import?

Thanks,

Dave

Code

Re: Import certain elements from XML into Access

Import certain elements from XML into Access