Right, examine the columns in the queries BEFORE the append because you are experiencing a mismatch in datatype. If you are unable to resolve it yourself a sample file containing the error is required for further assistance. (That shouldn’t come as a surprise seeing your a frequent visitor on this forum…)
1 Like