Uggggghhh! Autonumber not working on insert

[jwill]

Access 2010


Split Database


Trying to insert records but autonumber appears to be blocking my insert. This is the SQL code I'm using

insert into students(last_name, first_name, date_enrolled, sex, dob, stu_address_1, stu_city, stu_state, stu_zip)
select last_name, first_name, date_enrolled, sex, dob, stu_address_1, stu_city, stu_state, stu_zip
from student_data_dump;

I'm getting the error message "Microsoft Access can't append all the records in the append query"

This is really getting on my nerves. There is no primary key in student_data_dump and the autonumber field is not included in the INSERT INTO statement. What is going on!?!?!?!!? lol thanks in advance

[RuralGuy]

Why do you think it is the AutoNumber? How many records are you trying to append?

[jwill]

Why do you think it is the AutoNumber? How many records are you trying to append?

I'm trying to insert 32 records and I've looked over all the data and I can't imagine what else it would be. Maybe I should try removing the constraints from the table script for the primary key and see if that works. I'll let u know

[RuralGuy]

Are all of the incoming fields strings (text)?

[jwill]

Text and dates

[ssanfu]

According to the error message you attached, the query didn't add 32 records due to validation rules.
What validation rules do you have on the fields in the "students" table??