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.

Hi Kartik
As we have written custom code for you to read a file into access. What makes you think Access will have a built-in "import all files in a folder"? The answer is No.
This topic shows how to add all files to a folder and should be helpful.

Regards
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)