Home Forums Programming XML Problem Extracting Data from XML File into Field in SQL Server Table RE: Problem Extracting Data from XML File into Field in SQL Server Table

  • Hi Thom,

    Sorry for the delay replying.  Thank you very much for your help - the solution you suggested worked fine and imported the data correctly.

    Just one thing I am a little unsure on - in the code you posted, each value is prefixed with c.j..  Could I just ask what this refers to and whether it always needs to be c.j. or if it is just an alias and can be any characters?  Just so I know for when I am replicating this for other scripts that I'm working on.

    Thanks again for your help which I am extremely grateful for.

    Best regards,

    Ian