Import and Export Data with SQL Server Management Studio

Overview

The Import and Export wizard in SQL Server Management Studio (SSMS) assists users with copying data from one location to another. The export tasks let you export data into another database, Excel, text files, etc., and the import tasks let you load data from other databases or sources like Excel, text files, etc.

Explanation

The Import and Export wizard can be accessed by right-clicking on any database. Click Tasks and then click either Import Data… or Export Data…, as shown below.

Additional Information

• Simple way to export data from SQL Server
• Simple way to import data into SQL Server