How to import data using import and export wizard in SQL Server

Step-1: Open SQL Server Management Studio, connect to an instance.

Step-2: Expand databases & select the respective database to initiate the import process.

Step-3: Right click on that database and click on Import data. And then click "Next".

Step-4: Then choose the type of data source where you want to import the data from the drop down list (flat file or anything else).

Step-5: Then you can check the data using preview. Then click "Next".

Step-6: Then click on edit mapping to map the source file and destination table to import the data from. And then click "Next" to continue.

Edit Mapping

Step-7: Then it prompts you to run immediate or to save it as a SSIS Package. Check "run immediate".  And click "Next".

Step-8: Then click "Finish".

Step-9: Once the import is done you can see the screen as below then click on "Close".

Step-10: Lets see the output below.