Do it manually with the recorder turned on. That will create a macro
for you to use for the next time.

Explore the TransferSpreadsheet feature of Access to help you with your
import. You can call all of it from Access once you have the manual
steps figured out.

'Run the macro in Excel
'You will need the Excel library referenced in Access
Dim xls as Excel.Application
xls.Application.Run("MacroName")

'Import the spreadsheet into the Employee's table
DoCmd.TransferSpreadsheet acImport, 3, _
"Employees","C:\Lotus\Newemps.wk3", True, "A1:G12"

Hopefully, this will get you going.