APPENDING DATA TO ANOTHER TABLE
APPENDING DATA TO ANOTHER TABLE
(OP)
I am puzzled. I created table(table 1), copied it to another table (table 2), and then added several fields to table 2. I then used a query to delete the records in table 2, and attempted to append table 1 to table 2 (an append query). I keep getting a "Microsoft Access was unable to append all the data to the table" error message.
I could append data from table 1 to table 2 before I added the extra fields.
Any suggestion, comments, or work arounds? I am really stumped - this is critical to the processing data in a major application.
Thank you for whatever assistance you can provide.
JWJ
I could append data from table 1 to table 2 before I added the extra fields.
Any suggestion, comments, or work arounds? I am really stumped - this is critical to the processing data in a major application.
Thank you for whatever assistance you can provide.
JWJ
RE: APPENDING DATA TO ANOTHER TABLE
you should carefully read the error message it will usually tell you the reason like it couldn't append the records becuase
a cause duplicate key
b incorrect data types
c one or more of the fields have validation rules set
d no records exist in a related table
likely check that the later is not the cause as you might have set the required and or some other validation rule for the additional fields.
HTH
Robert