SQL Server and XML

SQL Server has support for XML. You can use the SQLXML add-on to do things like export and import tables from MSSQL and XML files and bulk load using SQLXML.

The new SELECT ... FOR XML syntax is very useful once you understand it. There is a discussion here about FOR XML.