+ Reply to Thread
Results 1 to 1 of 1

wrong encoding when importing data from web

  1. #1
    Registered User
    Join Date
    01-02-2010
    Location
    Tallinn, Estonia
    MS-Off Ver
    Excel 2007
    Posts
    1

    wrong encoding when importing data from web

    Hi,
    I am trying to import currency rate table from website into excel worksheet. Excel Web Query getting the data into worksheet but there is a problem with special characters like ü,õ,ä,š which is imported incorrectly as Ć¼,Ƶ,Ƥ,Å. Changing the encoding from Unicode (UTF-8) to Baltic (Windows) on Internet Explorer gives similar result on webpage.
    How can I set the correct encoding for Web Query when getting data including special characters?

    Example:
    Link to data I am importing (table starting with flag of United Arab Emirates):
    http://www.delfi.ee/valuuta/?l=wvaluuta
    First field of table should look like: Araabia Ühendemiraatide dirhem
    Imported field looks in my Excel sheet: Araabia �hendemiraatide dirhem
    Last edited by spacesnow; 01-02-2010 at 09:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1