Hello.
I am trying to import an Excel data sheet to an existing table in an Access database and I am getting an error message that all of the data was unable to be appended-the data was lost or deleted because of key violations. In the existing database, I have a field called entry_number, whose data type is auto number (one that is generated by the computer), that I stuck in there so that the database would have exactly one primary key and on the Excel data sheet, there is also a field or column called entry number, however it is not an auto number. I don't know whether or not this is why I am getting the error message, but I have a feeling this is the reason-one number is genearated and the other isn't (as far as the data goes). Is there a way for an Excel column or field to have a computer generated number, like Access allows you to have in tables, whenever a new record is inserted? Another thing that may be useful is that the Excel datasheet and the table in the database have the exact same field names and properties for them.
I hope I am making any sense. If any of you need clarification on this, please let me know. Thank you and I will appreciate any help you can give to me.
RTA
I am trying to import an Excel data sheet to an existing table in an Access database and I am getting an error message that all of the data was unable to be appended-the data was lost or deleted because of key violations. In the existing database, I have a field called entry_number, whose data type is auto number (one that is generated by the computer), that I stuck in there so that the database would have exactly one primary key and on the Excel data sheet, there is also a field or column called entry number, however it is not an auto number. I don't know whether or not this is why I am getting the error message, but I have a feeling this is the reason-one number is genearated and the other isn't (as far as the data goes). Is there a way for an Excel column or field to have a computer generated number, like Access allows you to have in tables, whenever a new record is inserted? Another thing that may be useful is that the Excel datasheet and the table in the database have the exact same field names and properties for them.
I hope I am making any sense. If any of you need clarification on this, please let me know. Thank you and I will appreciate any help you can give to me.
RTA