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

You can use SSIS package or Export Import wizard. But SSIS package give you more flexibility like defining transformation if any etc. Also if you create SSIS package using Visual Studio you can combine data from all your tables using UNION ALL in source query and export them in one shot to your sql table.

Otherwise you need to create export import task one ech for each of your tables to get their data to your table.

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c