Importing with an Autonumber PK

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

Guest

I have a table, tblCBAs, that contains an autonumber PK, social security
number, Test Name, and Test Grade fields. I imported the first time and had
access add the PK field.

No every time I attempt to import, using the File/Import command, into the
same table again I get deleted rows due to key violations and the records
that do "go in" have the SSN field in the Primary key fields and the test
name in the SSN field.

Anyone know why that would happen and/or how to fix it?
 
How? How are you "attempt[ing] to import"? Are you using a query? Are you
trying to copy/paste?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top