Solved

Excel 2007 unicode / utf-8 problem. French special charachters uploading incrorrectly

Posted on 2009-05-07
2
1,331 Views
Last Modified: 2012-05-06
Hi,

I have a feed that I upload to amazon.fr through an excel 2003 file with an add in that allows me to upload the data directly from the file.

All of the charachters / accents look absolutley fine my end but when they get to Amazon.fr
 à displays as à and  é displays as © and so on.

When somebody does teh sam eoperation from Amazon France on French version of excel this does not happen and the charachters display correctly!

I have tried:

-- pasting the data in to excel as special and choosing unicode.
-- changing to various fonts, including Arial Uncode MS

But the problem persists, anybodyhave any idea how I can solve this?

Thanks
0
Comment
Question by:alexealden
2 Comments
 
LVL 7

Accepted Solution

by:
coffeeshop earned 500 total points
ID: 24325383
I don't know if you can solve this by changing the language/codepage or something else on system level - maybe another expert has a solution for this.

But you can exchange the letters before output the data to the excel-file. I use this before uploading data into an oracle database, because another codepage is used there.

I wrote a little wrapper function for parsing all textfields, but only at base of a 255 character table (not unicode). This slows down the transfer/query, but it is the only solution I know.

If you do not find a better/faster way to solve this, I can post you my functions.
0
 

Author Comment

by:alexealden
ID: 24694026
Thanks I Solved this by uploading directly from a .txt file rather than using the interface supplied by Amazon. I
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now