Extracting XML Data from Multiple Folders

[adonahue15]

Hello - I have over 500 folders that contain XML files in each folder. I need to go through each folder and append the data from the XML files into my database.

Thanks for your help.

 

[Guus2005]

Here's some pseudo code:

use the dir command
for each object 
   if it is a directory 
     cd to that directory and do a dir ' (start from the top, this is a recursive function)
   else
     if it is a XML file
        read XML file into table
     else
        skip this file
     endif
  endif
next file

HTH