hello,
I have searched these forums, and also I have searched on Google to no avail.
I am experiencing a Key Violation in a Query/Append, which causes my Query/Append to do nothing.
This was not created by me, I have just been assigned to work on this Database, and this error keeps happening.
We have a table of information. We first clear the table, and then want to load the updated information from an External Excel File, into the Table. So the deletion of the Table works fine, but then upon Querying the Excel file, 575 records are found but then 0 are appended.
Does anyone have ideas?
None of the things already out there have been of any help so far..
I have searched these forums, and also I have searched on Google to no avail.
I am experiencing a Key Violation in a Query/Append, which causes my Query/Append to do nothing.
This was not created by me, I have just been assigned to work on this Database, and this error keeps happening.
We have a table of information. We first clear the table, and then want to load the updated information from an External Excel File, into the Table. So the deletion of the Table works fine, but then upon Querying the Excel file, 575 records are found but then 0 are appended.
Does anyone have ideas?
None of the things already out there have been of any help so far..