Subscript out of range - error message

[sg2808]

I am importing an excel file to the access DB.
The headers in the excel is same as the field names in the access and also the data type is properly defined.
However, I am still getting this error message.


Screen shot of the excel file is attached in a word doc. Sorry, do not have photoeditor to upload this as JPEG.

Any suggestion is much appreciated.

[NeoPa]

As you haven't posted any code showing what you're running to produce this error message, or even explained that you are running code anywhere in your question, I assume you must be running the import manually, but I can't imagine that error message associated with a manual import. It comes from blowing the bounds of an array of similar.

If the problem is actually triggered by a manual import directly then please confirm this and try to explain exactly what you see.

If the error message is actually from running code then please let me know and I will delete this question as nonsense and you can post it again properly.

[sg2808]

I was trying to import manually (no use of any code) and was getting this error message. So, instead of adding the data to the existing table (no data inside), I selected the first option of creating the table with spreadsheet data and I was successful.
Happy for you to delete this post.

Regards,

[NeoPa]

No need to delete if that's the case SG. Someone may be able to offer an explanation, which may no longer be necessary for you, but could prove helpful for someone-else looking into the same problem.

Thanks for confirming the situation :-)