Member Avatar for kartik07

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.

  • 2 Contributors
  • 3 Replies
  • 153 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by choudhuryshouvi
Member Avatar for kartik07

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.