Citat:
Originally posted by Jonas@Aug 21 2009, 08:09
MySQL-Front kan importera Excel
www.mysqlfront.de
|
Må vara sant men såg detta i deras forum.
Citat:
Swedish characters when IMPORTING from an Excel file
I'd like to ask for an advice how I could deal with non-English characters like å, ä and ö (a ring, a umlaut and o umlaut) when importing an Excel file.
I have got an xls-file I would like to import using MySQL-Front; Import >> MS Excel file . When reading the file in MS Excel I get the characters right, but when importing it into MySQL using MySQL-Front, I get some odd characters and not the correct ones.
An example: SörgÃ¥rdsvägen instead of Sörgårdsvägen.
An observation: In the importing process a screen is shown and there the letters are presented in the correct way. Likewise, table headings are appearing correct.
Hope yopu can help me to get this right!
|