Import CSV File into SQL Server

To demonstrate an import a csv file into  SQL Server I will use the following data set:

Penalty Charges CSV

Open Sql Server Management Studio(SSMS) , go to your database you want to import the data(In my case I have created a database called Parking).

Right click on the database >> Tasks >> Import Data...

blog_import_sql.PNGDataGen.png