SQL Server CVS Import

First, use the Import data tool:

Select data Source: Flat file Source, select a CSV,

Advance: Select all Columns (you can choose multiple, use shift),

Change outputcolumnwidth:500,

Change Datatype:unicode string [DT_WSTR]

Second, use the command:

　　

BULK INSERTHome from 'C:\users\lzl\desktop\home2.csv'  with(Rowterminator= '\ n', FieldTerminator= ','        --Firstrow=1,        --datafiletype = ' Widechar ',        --CODEPAGE = ' 936 ')

However, the second method in the processing of Chinese, there may be problems, SQL 2008 does not support the Utf-8 file format, you need to convert the UTF8 file to ANSI format.

SQL Server 2016 is currently found to support Utf-8

SQL Server CVS Import