XML data import

Hi All,
I have SQL 2008 Database called CRDB where is a table CDRDB.
Columns there are as follows:

IDNumber
MSISDN
RNORoute
Action

Please advice how to import (update table) XML data into Database with standard sql query.
I would like not to use third party toll to export XML data to different format and/or use a VBS script.
Please provide if possible a complete code. I would like to update an existing table records Thank you very much!

test.xml
...............
  <?xml version="1.0" encoding="UTF-8" ?>
- <CRDBData>
  <MessageName>CRDB Download</MessageName>
  <IDNumber>20070122151500SMRTCALLDnld001</IDNumber>
  <NumberOfMessages>2</NumberOfMessages>
  <Comments1>test delta downlaod</Comments1>
- <ActivatedNumbers>
- <ActivatedNumber>
  <IDNumber>2007011717050027830007510001</IDNumber>
  <MSISDN>99630007510</MSISDN>
  <RNORoute>D101</RNORoute>
  <Action>Return</Action>
  </ActivatedNumber>
- <ActivatedNumber>
  <IDNumber>2007011815250027830007532001</IDNumber>
  <MSISDN>99630007532</MSISDN>
  <RNORoute>D105</RNORoute>
  <Action>Return</Action>
  </ActivatedNumber>
   </ActivatedNumbers>
  </CRDBData>