I am appending a data from a single field table into a table with multiple fields and I received an error "microsoft access can't append all the records in the append query..." and it did append the specific data...
Can anybody help me?
Thanks & regards.
Table1; with following fields [Field1]
Table2; with the following fields [Field1], [Field2], [Field3]...
Here's the SQL code
UPDATE Table1 INNER JOIN [Table2] ON Table1.Field1 = [Table2].Field1 SET [Table2].[Field1] = [Table1].[Field1];