SQL Server - Import raw data file into SQL Server database

In SQL Server Management Studio, SQL Server Import and Export Wizard option is helpful to into your raw data into SQL Server database. Import Flat File provides us to create simple packages that import and export data between many popular data formats including databases, spreadsheets, and text files. The import and export wizard also create the destination database and the tables into which the data is inserted.

Import Text/CSV file into SQL Server follow below mention steps:

1. In SQL Server Management Studio, right click on the database and choose Import Flat File from tasks options
2. Specify Data Source as Flat File Source and Text/CSV file Location
3. Specify Export location Details
4. Mapping Source and Destination tables (Leave this option as it is)
5. Summary page to display our current configuration
6. RUN THE PACKAGE

To watch a demo here-