Conversion between Unicode and non-Unicode string data types is not allowed.

SQL/database technology 11:03:18 read 965 comments 0 font size: large, medium, and small subscriptions

I encountered another problem when I imported data in Excel ......

Error 0xc020f6: Data Flow task: the column "column" cannot be converted between Unicode and non-Unicode string data types.

Cause: After a closer look, we found that some fields are of the varchar type, while all the fields in Excel are of the nvarchar type.

Method:

1. Modify the table field type to nvarchar.

2. Import a temporary table and then insert *** into *** select ***.

3. Read the record set directly through the application, and then insert .......