I am totally newbie in this field and I need help. I've imported the data (10 tables) in SQL Server Management Studio from Excel file. All 10 tables have the same headers. Now I would like to merge all tables into one.
I've created Query for each table but don't know how to connect/copy data from Query to Table that I created in SQL.
Can someone help me?
Thank you in advance.