Error 0xc02020f6: Data Flow Task: Column "mDefault" cannot convert between unicode and non-unicode string data types.

I am trying to Import values from my excel spreadsheet into SQL and getting this:

Error 0xc02020f6: Data Flow Task: Column "mDefault" cannot convert between unicode and non-unicode string data types.(SQL Server Import and Export Wizard)

Suggestions?
LVL 7
Jeff SAsked:
Who is Participating?
 
Reza RadConsultant, TrainerCommented:
If datatype of column mDefault in your sql server table is varchar, text or char, change it to nvarchar, ntext or nchar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.