darthsmall
New Member
- Joined
- Sep 28, 2010
- Messages
- 1
Hi all
I'm trying to use the Data -> Import External Data -> New Web Query functionality in Excel 2003 SP3.
If I point the query at a standard web page, such as:
http://www.someDomain.com/someXML.xml?A=someData&B=moreData
I get the table back no issues with all available data elements.
My problem occurs if the argument passed has an accented character in it - the following fails to return correctly:
http://www.someDomain.com/someXML.xml?A=soméDátá&B=moréDátá
Is there any way to make web queries containing special characters perform correctly? Double or single quoting the argument doesn't work and I'm not quite sure what to try next.
Obvioulsy the example URL's above are fake, so don't click them
Many Tx for any repsonses/ideas.
./B
I'm trying to use the Data -> Import External Data -> New Web Query functionality in Excel 2003 SP3.
If I point the query at a standard web page, such as:
http://www.someDomain.com/someXML.xml?A=someData&B=moreData
I get the table back no issues with all available data elements.
My problem occurs if the argument passed has an accented character in it - the following fails to return correctly:
http://www.someDomain.com/someXML.xml?A=soméDátá&B=moréDátá
Is there any way to make web queries containing special characters perform correctly? Double or single quoting the argument doesn't work and I'm not quite sure what to try next.
Obvioulsy the example URL's above are fake, so don't click them
Many Tx for any repsonses/ideas.
./B