Copy data from one Excell sheet to another Excell Sheet using sql server 2000

Sheets("Master").copy



Sheets("Sheet1").Copy after:=Sheets(Sheets.Count)

Set NewSht = ActiveSheet





for copying multipel sheets



for i = 1 to sheets.count

Sheets(i).Copy after:=Sheets(Sheets.Count)

Set NewSht = ActiveSheet



next i

 string src = @"Book1.xlsx";

    string dst = @"Book2.xlsx";



    object missing = Missing.Value;



    ApplicationClass app = new ApplicationClass();

    WorkbookClass wb1 = (WorkbookClass) app.Workbooks.Open(src, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing,missing);

    WorkbookClass wb2 = (WorkbookClass)app.Workbooks.Open(dst, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);



    Worksheet sheet1 = (Worksheet) wb1.Worksheets["Sheet1"];

    Worksheet sheet2 = (Worksheet)wb2.Worksheets["Sheet1"];

    try

    {

        sheet1.Copy(sheet2,missing );

    }catch (Exception ex){

        //

    }

    finally{

        app.Quit();

    }

Regards,
Robin Ahuja

Thanks&Regards
LakshmiNarayana Nalluri.

sriram