Importing from Excel

I am trying to import from Excel and append to an existing table. My excel sheet is named tblStatus and I am trying to append it to my Access table "tblStatus".



I get an error message that says "The first row contains some data that can't be used for valid Access Field Names. In these cases, the wizard will automatically assign valid field names." (I used the excel sheet to set up my table.) After I click OK, I get to the point where I can click finish, and I get a "Subscript out of range" error.



MY row headers are:

strOrderOps

strOrderNo

strOperation

strOrderType

dtmBasicStartDate

dtmActualFinishDate

dtmCalFinishDate

strStatus



I am not sure what is going on.

Importing from Excel