Exporting in XML format

Is there a way of exporting data in XML format from SQL Server 2000, there is a wizard for exporting to a html file but I can't seem to find one to export into an XML file?A week and no replies?

All I want to do is create an XML document from sql server 2000 and have it written to a shared drive so I can read it from our webserver!

I know to produce on the fly such as SELECT * FROM VW_Web_Curr_Projs1 FOR XML AUTO, but how to write this result to an xml document
Or am I going about this the wrong way, any help please?|||

Take a look here

http://www.perfectxml.com/articles/XML/ExportSQLXML.asp

sql