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

N

Number2

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
Sending memo column data to HTML email 1
Use of INDIRECT and quotation marks 1
How to view Hawaiian characters with diacritical marks? 0
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
When I reply to some emails it is converted to question marks? 3
how do I change default to show spaces and paragraph marks? 1
I need to cut characters off of a list of text cells... 2

Top