CODE EXAMPLE FOR SQL

import data from csv to sql server

BULK INSERT SchoolsTemp
    FROM 'C:CSVDataSchools.csv'
    WITH
    (
    FIRSTROW = 2,
    FIELDTERMINATOR = ',',  --CSV field delimiter
    ROWTERMINATOR = '
',   --Use to shift the control to next row
    ERRORFILE = 'C:CSVDATASchoolsErrorRows.csv',
    TABLOCK
    )