Code: Select all
LOAD DATA INFILE 'C:\MyPath\Accounts.csv'
INTO TABLE Accounts
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
Any suggestions are appreciated.
Code: Select all
LOAD DATA INFILE 'C:\MyPath\Accounts.csv'
INTO TABLE Accounts
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
Code: Select all
BULK INSERT Accounts
FROM 'C:\MyPath\Accounts.csv'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2, --skip header row
TABLOCK
)