Microsoft SQL Server BULK INSERT


Example

BULK INSERT command can be used to import file into SQL Server:

BULK INSERT People
FROM 'f:\orders\people.csv'  

BULK INSERT command will map columns in files with columns in target table.