Start the SQL Server Import and Export Wizard from SQL Server Management Studio (SSMS)
-
In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine.
-
Expand Databases.
-
Right-click on your database.
-
Point to Tasks.
-
Click one of the following options.
-
Import Data
-
Export Data
-
If you don't have SQL Server installed, or you have SQL Server but don't have SQL Server Management Studio installed, see Download SQL Server Management Studio (SSMS).