ExcelBanter - How do I get SQL data to show CRLF instead of question marks?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get SQL data to show CRLF instead of question marks? (https://www.excelbanter.com/excel-discussion-misc-queries/248478-how-do-i-get-sql-data-show-crlf-instead-question-marks.html)

Number2

How do I get SQL data to show CRLF instead of question marks?

When I query my SQL database from Excel (currently 2007) I have some fields
that have carriage-return-line-feed characters and tab characters. These
show as square question marks. How can I make the CRLF and TAB characters
show up properly (without having to manually edit 5000 rows)?

All times are GMT +1. The time now is 06:25 AM.