Can't import with autonumber field

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
 
G

GVaught

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.
 

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

Top