Import Excel to Access

You have to place the following code in access

Private Sub Command0_Click()

DoCmd.TransferSpreadsheet acImport, , "compared", "c:\Auto_Helpdesk_Proforma", True, "a1:d2"
End Sub