Importing data into a database from a delimited file is perhaps one of the most common tasks that one might have to perform. SQL server gives us an import utility which supports various data sources and has an intutive interface as well,however there is another way which can be utilized to quickly get the job done, its called BULK INSERT BULK INSERT is a SQL command which can be typed in management console,takes various parameters to control the import and is very simple to use.