Excel 2007 Web Queries / Support scandinavian characters RRS feed

  • Question

  • Hello,

    There is a web service that returns DataSet with the data for web query. There is also web query that calls these web service. Number of columns in output data set depends on corresponding web query parameter.

    Web query can return data that contains special scandinavian characters like ä . Problem is that some times web query result contains characters like Aikaö instaed of ö.

    It is strange, because this behaviour (display ir right or using symbols ö) depends on selected columns only. I've tried to check what datasets are returned by web service, so they are the same, except additional column in the second.

    Is is possible to set somehow a web query setting to display correct special characters or set encoding directly in the returned dataset?

    Tuesday, September 14, 2010 2:05 PM