CREATE TABLE #tempXmlData (XmlData Xml)

BULK INSERT #tempXmlData
    FROM 'C:\Data.xml'
    WITH (DATAFILETYPE='widenative');

SELECT * FROM #tempXmlData;

DROP TABLE #tempXmlData