D
Dee
Hello,
I am trying to import excel spreadsheets into Access but I am having little
success. I can import the spreadsheet as a new table but when I try to append
to my contacts table Access tell me it can't import all of the records
because of key violations. My contacts table is empty. The records I want to
import does not have the same number of fields as the contacts table. The
primary key in the contacts table is an autonumber. Should I have a contactID
in the table I want to append. I don't understand how I will be able to
import the fields if there is no contact ID number in my imported table and
my contacts table is emply. Will they records be added and the next available
autonumber be used.
I don't know if I am making myself clear. I am having a bit of a problem
understanding why some of these records are added to my contacts table and
some aren't. I am using Access 203.
Is there are site they could help me understand what to do when I get these
error messages.
Thanks in advance for any help.
I am trying to import excel spreadsheets into Access but I am having little
success. I can import the spreadsheet as a new table but when I try to append
to my contacts table Access tell me it can't import all of the records
because of key violations. My contacts table is empty. The records I want to
import does not have the same number of fields as the contacts table. The
primary key in the contacts table is an autonumber. Should I have a contactID
in the table I want to append. I don't understand how I will be able to
import the fields if there is no contact ID number in my imported table and
my contacts table is emply. Will they records be added and the next available
autonumber be used.
I don't know if I am making myself clear. I am having a bit of a problem
understanding why some of these records are added to my contacts table and
some aren't. I am using Access 203.
Is there are site they could help me understand what to do when I get these
error messages.
Thanks in advance for any help.