title: Insert .xml file from my local machine into a single column of a SQL table
body: <p>I have a XML file in my local machine. I want to insert that file as <em>.xml</em> file into a single column of a SQL table.
  I tried searching internet and don't find any proper answer. I got some answers which explains how to insert the records as a single row but I don't want to split the record and I just want to insert that file as <em>.xml</em>.</p>
  
  <p>Screenshot:</p>
  
  <p><img src="https://i.stack.imgur.com/UGzOI.png" alt="enter image description here"></p>
  
  <p>the above record has been achieved my making calls through IVR but I want to read the file from local machine.</p>
  
  <p>XML file:</p>
  
  <pre><code>&lt;IVRDATA&gt;
    &lt;IVR&gt;
      &lt;CALLID&gt;84CAB60BABB711E4BDB9C7154A250D84&lt;/CALLID&gt;
      &lt;ICM_CALLID&gt;00-00-00&lt;/ICM_CALLID&gt;
      &lt;SESSIONID&gt;10.195.188.78.1423062943712.293.HFS_DCSS_CVP&lt;/SESSIONID&gt;
      &lt;APP_ID&gt;3&lt;/APP_ID&gt;
      &lt;APP_TYPE&gt;DCSS&lt;/APP_TYPE&gt;
      &lt;VXMLSERVER&gt;10.195.188.78&lt;/VXMLSERVER&gt;
      &lt;DNIS&gt;8523&lt;/DNIS&gt;
      &lt;CLI&gt;914461084538&lt;/CLI&gt;
      &lt;CALL_STARTDATETIME&gt;04/02/2015 09:15:43&lt;/CALL_STARTDATETIME&gt;
      &lt;CALL_ENDDATETIME&gt;04/02/2015 09:16:23&lt;/CALL_ENDDATETIME&gt;
      &lt;LANGCODE&gt;en-us&lt;/LANGCODE&gt;
      &lt;SKILLNAME&gt;HFS.DCSS.CSCC.en-us.SG&lt;/SKILLNAME&gt;
      &lt;AGENT_TRANSFER&gt;N&lt;/AGENT_TRANSFER&gt;
      &lt;ENDTYPE&gt;CD&lt;/ENDTYPE&gt;
      &lt;DISPOSITION&gt;CD&lt;/DISPOSITION&gt;
      &lt;HOW_CALL_ENDED&gt;HANGUP&lt;/HOW_CALL_ENDED&gt;
      &lt;CALL_END_REASON&gt;NORMAL&lt;/CALL_END_REASON&gt;
      &lt;CALLER_INPUT&gt;E&lt;/CALLER_INPUT&gt;
      &lt;FROM_EXT_VXML0&gt;HFS.DCSS.CSCC.en-us.SG&lt;/FROM_EXT_VXML0&gt;
      &lt;FROM_EXT_VXML1&gt;en-us&lt;/FROM_EXT_VXML1&gt;
      &lt;FROM_EXT_VXML2 /&gt;
      &lt;FROM_EXT_VXML3 /&gt;
      &lt;RTR_CL_KEY&gt;00&lt;/RTR_CL_KEY&gt;
      &lt;RTR_SEQ_NUM&gt;00&lt;/RTR_SEQ_NUM&gt;
      &lt;RTR_CL_KEY_DAY&gt;00&lt;/RTR_CL_KEY_DAY&gt;
      &lt;RES1 /&gt;
      &lt;RES2 /&gt;
      &lt;RES3 /&gt;
      &lt;RES4 /&gt;
      &lt;RES5 /&gt;
      &lt;RES6 /&gt;
      &lt;RES7 /&gt;
      &lt;RES8 /&gt;
      &lt;RES9 /&gt;
      &lt;RES10 /&gt;
    &lt;/IVR&gt;
    &lt;MENUDETAIL&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1001&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:43&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:15:47&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;1&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1002&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:47&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:15:48&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;1&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1054&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:48&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:15:48&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;1&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1038&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:48&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:15:51&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;NA&lt;/MENUOPTION&gt;
        &lt;MENUMODE /&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;D1003&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:51&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:15:59&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;198004947&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1039&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:15:59&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:16:03&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;1&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;D1004&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:16:03&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:16:15&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;359909410&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
      &lt;MENU&gt;
        &lt;MENUID&gt;M1041&lt;/MENUID&gt;
        &lt;MENU_STARTTIME&gt;04/02/2015 09:16:15&lt;/MENU_STARTTIME&gt;
        &lt;MENU_ENDTIME&gt;04/02/2015 09:16:17&lt;/MENU_ENDTIME&gt;
        &lt;MENUOPTION&gt;1&lt;/MENUOPTION&gt;
        &lt;MENUMODE&gt;dtmf&lt;/MENUMODE&gt;
        &lt;MNURES1&gt;NA&lt;/MNURES1&gt;
        &lt;MNURES2&gt;NA&lt;/MNURES2&gt;
      &lt;/MENU&gt;
    &lt;/MENUDETAIL&gt;
    &lt;EVENTDETAIL&gt;
      &lt;EVENT&gt;
        &lt;EVENTID&gt;DC001&lt;/EVENTID&gt;
        &lt;EVENT_TIME&gt;04/02/2015 09:15:47&lt;/EVENT_TIME&gt;
        &lt;EVNRES1 /&gt;
        &lt;EVNRES2 /&gt;
      &lt;/EVENT&gt;
    &lt;/EVENTDETAIL&gt;
  &lt;/IVRDATA&gt;
  </code></pre>