Importing from Excel (1 Viewer)

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.

Are you using the Wizard to Import? Have you tried looking at a MACRO to do the import?

If you struggle perhaps zip an extract of the spreadsheet and Database so we can take a look at it for you and advice further.

I have ran into a similar issue with importing a spreadsheet. Turns out one of my headers on the worksheet had a hyperlink embedded in it.

What method have you tried?

I found my problem. There was some deleted data in a column outside the required columns. When I deleted those columns, it cured my problem.