1: Is there any way to covert the xml data into Excel workSheet?
2: Also from database (sql server 2005 ) to an Excel worksheet?
+1
A:
You can export data from a Sql Server database to excel. See this link and this one.
As for an xml file, you can easily just open the xml file in Excel. Depending on the format it should open up for you fine.
David Basarab
2009-10-12 12:27:21
+1
A:
This is a straight forward one, well documented in Microsoft site http://office.microsoft.com/en-us/excel/HP010423511033.aspx
If you are talking about doing it programatically, I think the first answer is a good start.
Faiz
2009-10-12 12:31:17