Forum Discussion
Append query - extra column appear
Hi,
I am having a problem with appending queries.
I have 4 tables that I imported from excel. I want to combine all the tables and have them as one table. The attributes inside each table are year, state, sales and so on. In the new table, i was supposed to have 5 columns but I found i had 6. The extra column appeared as Sales, but showing null in each cell.
I really don't know where the mistake is. I checked the original 4 tables and the 5 columns. Nothing wrong. Does anyone know what happened?
Thanks!
make sure that all the columns for all the excels are named the same and make sure also that the data type of columns for all excels are the same,
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
4 Replies
make sure that all the columns for all the excels are named the same and make sure also that the data type of columns for all excels are the same,
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Thank you! I chekced what you mentioned and it finally worked out!
