Forum Discussion
Append Query duplicates some columns
Oh my word...!!!
So, before I basj myself over the head, let me share my mistake with you...
The issue was quite definitely different column names - there were some trailing spaces in the names of the 4 columns in my 2nd table. I had however checked for this earlier, within Excel, using a pattern match to identify any spelling differences, howeve it appears that the Excel pattern match excluded trailing spaces, and thus did not alert me to the fact that the column names were in fact not the same.
Ah well, thanks for listening... ;-)
Oh my word...!!!
So, before I basj myself over the head, let me share my mistake with you...
The issue was quite definitely different column names - there were some trailing spaces in the names of the 4 columns in my 2nd table. I had however checked for this earlier, within Excel, using a pattern match to identify any spelling differences, howeve it appears that the Excel pattern match excluded trailing spaces, and thus did not alert me to the fact that the column names were in fact not the same.
Ah well, thanks for listening... ;-)
Thanks for this - I ran into the same thing and couldnt figure out why. The table had a space after the last letter of the column name. All fixed!