SQL Server Bulk Import Script

Nice easy copy and paste SQL Server bulk import script:


CREATE DATABASE databasename
USE databasename


CREATE TABLE tablename
(
        id     int
,       col2      date
,       col3     float
)


BULK INSERT tablename
FROM 'C:\datalocation\filename.csv'
WITH
(
MAXERRORS = 0,
FIRSTROW = 2, -- i.e. 2 if has a header row on line 1
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)