Subscript out of range. I am getting a subscript out of range message when attempting to import an Excel spreadsheet into a NEW table. I have seen a couple other references to this problem, but the recommendation seems to be redefine the table columns. However, in this case I'm letting Access create the table.e: Subscript out of range. i find this with importing excel-if there has EVER been data (I assume) in an excel row/column it (tries to) import the blank data-which can cause issues if you are loading it into an existing table, with insufficient columns.