Forum Discussion
wi11iamr
9 years agoAdvocate II
Append Query duplicates some columns
Hi there, I have two identical tables (daya from FY2016 and FY2017) and am using an Append Query to merge them into a new combined table. Using the Append Query function, there are 4 columns ...
- 9 years ago
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... ;-)
hourir2
5 years agoAdvocate I
Thanks for this, helped me out!!