When I import data into a table from an excel spreadsheet I receive the following error message:
"1 record was lost due to key violations."
-The primary key is the date. The record I am importing has a unique date.
-Column headings match field names.
What could be the problem?
Thanks.