Append Query 1

[snowyowl]

How do you copy data from one table in one database to another table in another database which is the same but it has new fields.

I've tried an append query but it keeps coming up with validation violations stopping it from copying.

I've tried just one field and it still does not copy.

 

[Isadore]

snow: just link your tables between databases and run the appropriate update query.

 

[KornGeek]

If I understand correctly, you're saying the destination table has fields the source table doesn't. I'm guessing the validation violations are due to one or more of these fields not allowing Nulls (Required property set to True) or some sort of validation rule is set. In your query, you may need to set a value for these fields, or go into the table and change the properties for these fields.