Hi all,
       I need the VBA code to transfer data present in the database table of Access into an Excel sheet.

 all u need is to use the export to command in the macros section.

filling the parameters
1.name of tablein accessu want to export to.
2.the format u want it exported to excel.
that all

Simple:

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
        TableName, ExcelFile, , SheetName

You can leave off the SheetName and the last 2 commas to put your table in the default sheet (which I believe is "Sheet1"). Note that you can also use a query name in place of the table name.

-Phil-