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

Hello team,

I have a project that I need to do, what is the best approach for each step?

1- I have to create a table in Microsoft SQL Server.

2- I have to import data/ tables from Microsoft Excel or Access to Microsoft SQL Server. Should I use Microsoft Visual Studio to move data from Excel or Access?

3-I should populate the created table with the data from the exported data.

4-How should I add the second and third imported table to the first table? Should I use union query?

After I learn these, I will bring up the code to make sure what I do is right.

Thanks for all,

Guity

---

GGGGGNNNNN