Import and export SQL data to Excel file

Import and export SQL data to Excel file

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.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *