Hi! New poster here. I seemingly have a simple task, however as there likely are different solutions, hoping to have some ideas which would be best. I have Table1 and Table2, both connected to SQL database over Microsoft Query. I have no problem refreshing them over VBA but after refresh, I also need to combine them.
I want to combine them in Table3 in order to sort, analyze and present it as a single dataset. I have set Table1 and 2 both to have identical data structure, so they'd fit similarly into Table3.
Created a simplified mockup of what I'm looking for. And just for clarification - I'm currently converting dt_string into proper Date with Excel DATE function already in both Table1 and Table2, so technically not all data is coming from SQL connection, however I can leave the date conversion only to Table3 too.
append.jpg
Bookmarks