Today I will show you how to export and import data between SQL server and Excel file. I thing it will be usable for you.
To make import please open SQL Server Management studio, connect to SQL server and right-click on our DB.


Choose file to be imported.

in my case import file looks likt that:





Results are:

Now will show hot to export data from DB to excel.









