I'm exporting a SQL table to Excel. It fails on the first column which is varchar(50) in the table
Error: Cannot convert between unicode and non- unicode data type.
I can't find where I could change DT_WSTR to DT_STR or visa versa.
But I changed the data type in the table from varchar to nvarchar. Still get the same error.