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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Indexed 'error' when changing index in table 2
Importing from Excel 2
Importing Data from Spreadsheet - Efficient Design 1
Number Data Type Unavailable 1
Import new data and replace old data in Access table. 4
Importing unique records from excel into access 2

Back
Top