Create a table in SQL Server, Export tables from Microsoft Excel to Microsoft SQL Server, Populate the created table

I am planning to take these steps:

1-Create a table inside SQL Server

2- I will write down this code to populate the created table with the values from imported table:

INSERT INTO dbo.Orders(OrderId, OrderDate)

SELECT OrderId, OrderDate

FROM Sales.Orders

UNION

SELECT OrderId, OrderDate

FROM Sales.Orders1

Union

SELECT OrderId, OrderDate

FROM Sales.Orders2

Is the top code correct? Please advise me.

Regards,

Guity

---

GGGGGNNNNN