You're not giving us much to go on. Where is the 'data' to which you
refer. In a table? A query? Which versions of Access and Excel? When
this separate file saves, should it also contain the rest of the Excel
sheet to which you imported the data, or just the data  itself? (NB in
the latter case, it will be much, much easier simply to export to a file
straight from Access.)

The more detail we have, the more likely we are to be able to help.

I am using excel  2000 and Access 2000.

I am retrieving the data  from the table.I need to put two buttons on the front
page of the excel sheet.When user  clicks first button  it should retrieve the
data from a table and display in the first sheet  i.e sheet1 and similarly when
he clicks  the second button it shouls export the data to the second sheet i.e
sheet2 of the same excel workbook.

I too just now started to work on this one.Please help  if possible.Please
reply if you any doubt i am ready to reply.

OK. Part 1 is the import from the table into Excel. This page  shows a
god method:


www.exceltip.com/.../Import_data_fr
om_Access_to_Excel_(ADO)_using_VBA_in_Microsoft_Excel/427.html

The second is moving it to another sheet  in the same workbook. The easy
way is simply to copy the worksheet. Try this code:

Sheets("Sheet1").Copy Before:=Sheets(2)

I think it will help  me a lot to proceed in my work.i will
get back u if i find any problem.