I am trying to append query from one db to another one (tried a linked table or directly to it). The table is exactly the same. When I run it I get an error message. Here is error message I get.
Cant append all the reocrd in the append query.
Db set 0 fields to Null due to a type conversion failure, and it didn't add 3 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations.
any ideas,
Kelly
Cant append all the reocrd in the append query.
Db set 0 fields to Null due to a type conversion failure, and it didn't add 3 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations.
any ideas,
Kelly