Duplicating Data in Tables

M

Michael_100

When I import data from an Excel spreadsheet into an Access table when
existing data is on the table, the existing data is sometimes duplicated. Has
anyone else experienced this and how do I resolve this issue?

Thanks in advcance for any help!
 
J

Jeff Boyce

Michael

"duplicated" is a fairly ambiguous description ... are entire records being
duplicated (i.e., entered more than once), or are particular fields within
records being duplicated (same value more than once).

If your entire record is being duplicated, you'd need a primary key in your
table that uniquely identifies the record, so that attempts to add identical
data would fail.

Regards

Jeff Boyce
<Office/Access MVP>
 
Top