That depends on how you want to import it; via code or SSIS.
For SSIS you may want to look at this http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx
For code there is nothing special. Parse the xml and insert.
If you give a little more detail maybe we can give you a more specific answer