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.