Append Query

[JCMcAbee]

Hello and thanks in advance.

I am trying to append 281 records from one table into another in the same database. I know this is a very basic process aand should be easy, but for some reason, I am having a heck of a time getting it to work. The fields in the table I am trying to append from are identical to the fields in the table I am trying to append to. However, when I run the query I get the error "MS Access can't append all the records...281 records due to validation rule violations". I have checked all the properties to ensure that they are identical. I do not have any validation rules set in any fields of both tables. I followed the help instructions, but cannot get it to work.

What am I overlooking, or doing wrong?

 

[fneily]

If you're sure you have do validation rules in the field properties of the tables, do the fields have the same data types? Maybe there's a numeric where text should be.

 

[JCMcAbee]

Thanks for reply. I have checked the data types and they are identical. I have also tried appending just one field instead of multiples, but I get the same error. The append to table does have more fields than the append from table, and the append from fields are also in the append to table. According to 'help', both tables do not have the same number of fields.
Thanks again.

 

[lespaul]

The append to table does have more fields than the append from table, and the append from fields are also in the append to table

what is the query? Since there are not an equivalent number of fields in each table, you'll need to specify the field names...have you done that?

INSERT INTO Table (Field1, Field2, Field3) (SELECT Field1, Field2, Field3 FROM OtherTable)

Leslie

Have you met Hardy Heron?

 

[dhookom]

Do you have some relational integrity set up between your target table and other tables?

Duane
Hook'D on Access
MS Access MVP