Duplicating Data in Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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>
 
Back
Top