Excel ODBC Query - Symbols - encoding issue?
Posted on 2011-05-12
I use an ODBC connection to pull in data into Excel 2010 from a database. There are a lot of "copyright" symbols in the text, like women’s and Rider™
I need these converted back to read women’s and Rider™ in excel in in order for someone else to import into another system. I believe it has something to do with encoding (needs to be UTF-8??), but I'm not very familiar with the topic.