Thread: How do I get SQL data to show CRLF instead of question marks?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Number2 Number2 is offline
external usenet poster
  
Posts: 1
Default 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)?
Reply With QuoteReply With Quote