I'm trying to upload an Excel file into Access and I keep getting an error
message. It says: "Index or primary key cannot contain a Null value." When I
click "show help" directly below this error message, I am told:
This error can be caused by one of the following:
(1) The maximum number of columns allowed in a table or the maximum
number of locks for a single file is exceeded.
(2) The indexed property of a field is changed from Yes
(Duplicates OK) to Yes (No Duplicates) when duplicate data exists in
the table.
(3) An expression is not specified in the Expression
property of a calculated field.
I've looked and there don't seem to be any non-numerical values in the
column that I want to set as my primary key. Any idea what might be causing the
problem? I've attached a copy of the file, for reference. (I want to set
the "ORF Name" column as the primary key.) Thanks!