Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Excel Web Query not displaying umlaut character correctly

I have a web query that is pulling some customer information from a web site.
I have a case where a customer name has a umlaut i.e. Universitätstrasse or
ZÜRICH. It looks correct on the web site but when I run the web query the
characters look like this Universitätstrasse and this ETH Zürich. If I copy
and paste the data from the web to Excel it works perfectly. I have also
tested it with an ASP script that just grabs the data and sends it to Excel
and that works perfectly. It only occurs when the data is passed via a web
query in Excel. Any ideas on how to fix this?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XY charts not displaying correctly in Excel 2007 RodW Charts and Charting in Excel 1 September 8th 09 12:41 PM
Date not displaying correctly Clark Excel Worksheet Functions 6 October 2nd 08 07:17 PM
Axis Not Displaying Correctly DATDANGGADUDE Excel Discussion (Misc queries) 0 April 4th 08 03:35 PM
Excel does not displaying formatting correctly Cookie Excel Discussion (Misc queries) 2 April 24th 06 02:55 PM
Character/Symbols not displaying correctly in this web forum ??? needyourhelp Excel Discussion (Misc queries) 1 May 25th 05 05:46 PM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"