Linked table to Excel Sheet

This line will create a linked table to specified worksheet (MySheetName)  in Excel workbook:

DoCmd.TransferSpreadsheet acLink,acSpreadsheetTypeExcel9, "MyTable", "C:\MyFile.xls", , "MySheetName$"