Export XML from SQL Server

[Rjconrep]

I am new to both XML and SQL Server so please be patient. I have ten excel files that need to be imported into SQL server. This part of my job is done. What I need now is to export these files as tagged XML files.
How do I export as XML from SQL server?

 

[tsuji]

You should probably get more direct and prompt advice from sql forum

http://www.tek-tips.com/threadminder.cfm?pid=183

 

[harebrain]

Try something like

SELECT * FROM yourtable FOR XML AUTO

BOL is your friend--search for for xml and openxml.