What is the best way to Import Excel Tables into SQL Server (SSMS)? I am pretty new to using SQL, writing queries has been pretty straightforward to learn but I am having difficulty finding a good way to import my data from excel into SQL Server.  


The company I work for has a million different databases that are constantly changing. I can go into any of them and export the data to excel. The table headers don't change very often, but the data changes every day. I just want an exact mimic of these tables to be put into SQL so I can start joining and working the data.  


My question is: what would be the best way to copy excel data with headers into SQL for use in SSMS? My current attempt had been to use SSIS to build a Control Flow. Any advice or training sources would be great. Thanks