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

Number2

Guest

Posts: n/a

15th Nov 2009

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

« need help in formula | Changing the screen tip on a custom button, Name change does not w »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why do quotation marks change to question marks in e-mails receiv.	=?Utf-8?B?SiBIZXJuZG9u?=	Microsoft Outlook Discussion	0	30th May 2007 08:01 PM
Word should filter revision marks: show marks after given date.	=?Utf-8?B?QnJpYW4gV29uZw==?=	Microsoft Word Document Management	1	3rd May 2006 03:27 AM
Japanese fonts show as question marks	=?Utf-8?B?UldlbHNo?=	Microsoft Outlook Contacts	0	26th Oct 2005 02:46 PM
Show field with CRLF ?	Jason	Microsoft Access	4	24th Mar 2005 05:28 AM
contacts show as question marks	Ali	Microsoft Outlook Contacts	0	26th May 2004 01:25 PM