I have created a table as follows:
CREATE TABLE DBase_Editor
(
sku nvarchar (max) not null,
title nvarchar (max) null,
price money not null,
condition nvarchar (max) not null,
author nvarchar (max) null,
sellers int null,
usedsellers int null,
isbn varchar (13) not null,
availability nvarchar (max) null,
comments money null
)
But when I try to load the attached file using
BULK INSERT DBase_Editor
FROM 'G:\DBase Editor.csv'
WITH
(
Firstrow = 2,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
I get the above message. (Please note I saved it as a .txt file for purpose of posting it here only as EE doesn't accept CSV files. I do have it saved as CSV when I try to load it). I am getting A LOT of them, in fact I get so many it says "exceeded maximum number of errors" See below. Any help appreciated.
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 3 (price).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 15, column 3 (price).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 16, column 10 (comments).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 17, column 10 (comments).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 22, column 10 (comments).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 23, column 10 (comments).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 32, column 3 (price).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 33, column 3 (price).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 46, column 10 (comments).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 49, column 6 (sellers).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 70, column 3 (price).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
