I have received a XML file that looks like

<Root>
   <Record>
      <Name>John</Name>
      <Age>42</Age>
   </Record>
   <Record>
      <Name>Jeff</Name>
      <Age>18</Age>
      <State>VA</State>
   </Record>
   <Record>
      <Name>Judy</Name>
      <City>Raleigh</City>
      <State>NC</State>
   </Record>
</Root>

and need to insert the data in Employee table that has the following structure:

	<Emp_Name>  <varchar> (50) NOT NULL 
	<Emp_Age>   <int>          NULL 
	<Emp_City>  <varchar> (50) NULL 
	<Emp_State> <varchar> (50) NULL 

Is there an easy way to do this?

A response on this board and in an email to DRouleau@scc.virginia.gov would be greatly appreciated.

Thank you,
Daniel