Can't import with autonumber field

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I just converted an Access 97 database to Access 2000. In
the 2000 version when I try to import a txt file into a
table that has an AutoNumber field I receive the error
message "Microsoft Access was unable to append all the
data to the table". I do not have this problem with 97,
and when I remove the AutoNumber from the 2000 version
everything works fine. Any suggestions?
- Matt
 
Are you trying to fill in the AutoNumber field with a value? If so, the
import will fail. AutoNumber fields are generally set as primary keys and
thus can't not have repeating values nor can you prefill in this value.
Generally when you import records from a txt or xls file you leave off
importing into the Autonumber field as the records are added Access will
assign a value to the record.

Hope this helps.
 
Back
Top