Launch Excel and open the spreadsheet you wish to load into Access. Verify that the spreadsheet's column names match the Access table's field names.

I've been surprised in the past how I've been unable to File->import excel data into Access, but copy and pasting into a table has been no problem.