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.