"Bulk load data conversion error (type mismatch or invalid character for the specified codepage)" when trying to Bulk Insert in SQL Server 2019

Viewed 68

I am trying to run the following:

BULK INSERT nashvilleHousing 
FROM 'C:\Users\Bruce\Downloads\Nashville Housing Data for Data Cleaning (2).csv'
WITH (
      FIRSTROW = 2, 
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
     );

To insert the following CSV data:

I have attached screenshots of the source csv file.

Apologies if this appears somewhat messy.

I get the following repeating error:

Msg 4864, Level 16, State 1, Line 35
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 4 (SalePrice).

This extends downwards to all rows in the original file (so row 3, column 4; row 4, column 4; etc....)

I have tried changing ROWTERMINATOR and FIELDTERMINATOR, and scanning the source data for errors. No luck.

0 Answers
Related