XML to database

Jan 30 2004 4:36 PM
I have an XML file that I need to read... A sample file is as follows... 111 2004 1 6 10 11 43 2 file1.txt ASN 123 file2.txt LTR 124 The section will be a record in on table with FileNumber as the PrimaryKey (PK). FILEPROCESS FileNumber (PK) ProcessDate For each in the section.. a record will be inserted into a second table... FILEPROCESS_DETAIL FileNumber FileName ImportType DetailFileNumber **This is not related to the higher level FileNumber How do I do this using a for loop and variable while looking at the Name of the XMLNodeType.Element?? I am not familar with reading XML Please... any help...