Vba xml (1 Viewer)

rasputnik · Jun 12, 2013

I am new to access vba and need to read this xml file and put it into three differents tables (tblparametri, tblofferta,tblarticoli). How can i do it?
Thanks a lot.
Here's my xml file:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<exportPQ>
<parametri>
<codeOff>00013-00054</codeOff>
</parametri>
<offerta>
<codice>00013-00054 </codice>
<descrizione>PROVA DI NUOVO</descrizione>
</offerta>
<articoli>
<codice>132002</codice>
<modello>TG1200P</modello>
<rifFornitore>3</rifFornitore>
<descrizBreve>TAVOLO SU GAMBE DA 1200 MM</descrizBreve>
<importoListino>477,36</importoListino>
<scontoVendita>0;0;0</scontoVendita>
<importoUnitario>477,36</importoUnitario>
<quantita>1</quantita>
</articoli>
<articoli>
<codice>132003</codice>
<modello>TG1300P</modello>
<rifFornitore>3</rifFornitore>
<descrizBreve>TAVOLO SU GAMBE DA 2400 MM</descrizBreve>
<importoListino>477,36</importoListino>
<scontoVendita>0;0;0</scontoVendita>
<importoUnitario>477,36</importoUnitario>
<quantita>1</quantita>
</articoli>
</exportPQ>

speakers_86 · Jun 12, 2013

You need to use the Microsoft XML 6.0 referrence. Here's a good reference:

http://www.w3schools.com/xpath/xpath_syntax.asp

Heres an example of how to use the library reference:

Code:

Public Sub test()
 
Dim objXML as DOMDocument60
set objXML  = New DOMDocument60
objXML.Load("Your Path Here")
 
Msgbox objXML.xml
 
Dim node as IXMLDOMNode
Set node = objXML.selectSingleNode("/exportPQ")
msgbox node.xml
 
Dim nodes as IXMLDOMNodeList
set nodes=objXML.selectNodes("/exportPQ")
msgbox nodes.length
 
dim node2 as ixmldomnode
'I used a modified version of you xml for testing, but you can see how it works.
set node2 = objxml.selectSingleNode("exportPQ/parametri/test[id='2']")
msgbox node2.xml
 
set node2=nothing
set nodes=nothing
set node=nothing
 
End Sub

Rx_ · Jun 12, 2013

That is a great site to get started. Here is my code from a previous post if that helps: http://www.access-programmers.co.uk/forums/showthread.php?t=242332

Here are a couple of other XML VBA related post for what it is worth.:
http://www.access-programmers.co.uk/forums/showthread.php?t=244622
http://www.access-programmers.co.uk/forums/showthread.php?t=243732

Vba xml (1 Viewer)

rasputnik

New member

speakers_86

Registered User.

Rx_

Nothing In Moderation

Similar threads

Users who are viewing this thread