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
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
In the new versions of MSSQL Studio there is no built-in enhanced import feature.