Hi,
You can do this by writing to a Excel file much in the same way as to 

any
other database.Just follow the simple steps..
1)Create a connection object like this
 connstr= "DBQ=" & server.MapPath("Report/Report.xls") & ";Driver=  

{Microsoft Excel Driver (*.xls)};ReadOnly=0"
 ExcelCon.open connstr
2) Create a form in the Excel sheet by
  a> select all
  b>go to insert>name>add a name>press okay
3> You can now write to a Excel much in the same way as to SQL 

database.

Good Luck,

> Hi all,
> I am displaying data in  the browser in a table format.
> I want to provide a facility where the user can DUMP data in to a "Excel
> Sheet"  with a click of a button.
> Means, if a user presses a button then the data from the table should be
> automatically transferred to an "Excel sheet" with a File name at a 
definite
> place.
> 
> Thanks in Advance,
> 
> TejoPanini
> tejo_nemalikanti@s...
>