Forum Discussion
polman4
Helper I
Helper IMerge 3 tables (Append?)
Hello, I have 3 different tables that I would like to merge into one. Actually from what I understand i need to do an append query but everything I tried is not working fine. Below you find t...
KNP
Super User
Super UserSorry, I just reread your post, I understand the column structure better now.
I think what you actually need to do is rename the columns of each of the three tables prior to the append.
If each of the three files you have are at least consistent (individually) you could just do the rename on the three files and then append.