Hello and thanks for stopping by,
I am new to Access and have been tasked with updating a 30+ year database. The database has 10 tables, 9 of which provide various information and are linked "relationship-wise" to the 10th by a primary key given to each data entry into this database. My current task is to bring in an excel file that contains this years collected data and update all these tables with the newly sampled data. To explore if this is even possible, I grabbed a subset of the data to be entered and manually assigned them primary keys (if the sampled individual was "new" this year) or checked in the Access database for a previously assigned primary key (if the sampled individual was "re-sampled" this year). Once this was done, I attempted to import my Excel file into the appropriate Access table and was met with this error:
The contents of fields in 0 record(s) were deleted, and 23 record(s) were lost due to key violations.
*If data was deleted, the data you pasted or imported doesn't match the field data types of FieldSize property in the destination table.
*If records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violated referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?
What I get from this is that the 23 records that were "re-sampled" this year in the Excel file (that were previously assigned a primary key) are not updating ("merging") as I hoped they would...
So, is there a way to bring BOTH new data and old data from an Excel file into Access?
Thank you very much for reading and I hope you have a wonderful day.
Sincerely,
Shawn