Sample CSV File Content:
| FOO,BAR,BAZ |
| FOO,BAZ,BAR |
| BAR,FOO,BAZ |
| BAR,BAZ,FOO |
| BAZ,FOO,BAR |
| BAZ,BAR,FOO |
Example 1:
| USE DATABASE_NAME |
| GO |
| --CREATE TABLE TO INSERT DATA INTO |
| CREATE TABLE TABLE_TO_IMPORT_INTO |
| (COLUMN1 VARCHAR(50), |
| COLUMN2 VARCHAR(50), |
| COLUMN3 VARCHAR(50)) |
| GO |
| --BULK INSERT THE DATA FROM THE CSV FILE |
| BULK INSERT TABLE_TO_IMPORT_INTO |
| FROM 'c:\filename.csv' |
| WITH |
| ( |
| FIELDTERMINATOR = ',', |
| ROWTERMINATOR = '\n' |
| ) |
| GO |
| --VIEW THE DATA INSERTED |
| SELECT * FROM TABLE_TO_IMPORT_INTO |
| GO |
| |
Example 2:
| USE DATABASE_NAME |
| GO |
| --CREATE TABLE TO INSERT DATA INTO |
| CREATE TABLE TABLE_TO_IMPORT_INTO |
| (COLUMN1 VARCHAR(50), |
| COLUMN2 VARCHAR(50), |
| COLUMN3 VARCHAR(50)) |
| GO |
| --INSERT THE DATA FROM THE CSV FILE |
| SELECT * |
| INTO TABLE_TO_IMPORT_INTO |
| FROM |
| OPENROWSET('MSDASQL', |
| 'Driver={Microsoft Text Driver (*.txt; *.csv)}; |
| DEFAULTDIR=C:\;Extensions=CSV;', |
| 'SELECT * FROM filename.csv') |
| GO |
| --VIEW THE DATA INSERTED |
| SELECT * FROM TABLE_TO_IMPORT_INTO |
| GO |
| |