I am running SQL Server 2008R2 and trying to import .csv file data into a table.
The problem is that i have some values in the file that are missing (NULL).
CREATE TABLE [dbo].[A](
[coid] [varchar](256) NULL,
[said] [varchar](15) NULL
bulk insert dbo.A
fieldterminator = ','
,rowterminator = ''
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (coid).
Question: is there way to filter NULL values? Perhaps there is another way, besides bulk insert to do it?