Import all XML files from directory to ACCESS
hi ,
I am new to VB6 and as part of my project,I need to create a module
which imports XML files from a directory and stores in a singleDB(I
am using ACCESS 2007).
All the XML files wil be stored in a directory;say c:\project.
Let table name=ABC
ABC contains following fields:
1.ID
2.FAULTID
3.DATEOFOCCURENCE
4.TIMEOFOCCURENCE

Consider the xml files
a1.xml
<MACHINE>
<ID>12</ID>
<FAULTID>F001</FAULTID>
<DOO>12.12.02</DOO>
<TOO>11.56.34</TOO>
</MACHINE>
a2.xml
<MACHINE>
<ID>67</ID>
<FAULTID>F002</FAULTID>
<DOO>12.11.97</DOO>
<TOO>12.34.34</TOO>
</MACHINE>
a3.xml
<MACHINE>
<ID>52</ID>
<FAULTID>F001</FAULTID>
<DOO>12.09.02</DOO>
<TOO>13.53.34</TOO>
</MACHINE>
Can anyone tel me how to do it.I need it urgently.

Hi,
I recently installed ACCESS 2007.Is there any provision in ACCESS2007 to import all XML Files in a given directory??Check out the attachment saying XML import ex.

This article has been dead for over six months. Start a new discussion instead.