can anybody tell me how to transfer xml data to an excel template (worksheet)

Hi Ganesh,

Regarding this issue of transferring the XML datato an excel template, I
would request you to please go through teh following article to transfer the
data from an access database to Microsoft Office Excel 2003. These include
using the user-Interface, programmatically creating an XML file,
transforming the data and reading it into Excel, and automating Excel and
programmatically reading the data file :

[Transfer XML Data to Microsoft Office Excel 2003 with Microsoft Visual
Basic .NET]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xltransferxmltoxlwVB.asp

Hope this helps.

Regards,
Mona [Grapecity]

[quoted text, click to view]