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 [sig][/sig]
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 [sig][/sig]