im no XML expert but, i use this command to import xml files in to my database, I created a SP using the dynamic SQL so i can pass it a location and file name.

insert into #xml_table SELECT * FROM OPENROWSET(BULK N'c:\temp\filename.xml', SINGLE_CLOB) AS xmldata

set @XML_exec ='insert into #xml_table SELECT * FROM OPENROWSET(BULK N'+char(39)+@file+char(39)+', SINGLE_CLOB) AS xmldata'

Exec (@XML_exec)