Accents not keeping from PC to Mac

[cmargetts]

Version: v.X Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello,
I am having issues with PC data showing up the same on my MAC. My partner generates a pre sorted data list from the customers original excel file. He has given me the data in a .csv, .dbf, .xls fiel but I'm running into the same problems with all 3 files. All the accents over the spanish names are being transformed into different characters. Just for giggles I tested all 3 Files on a different PC, and both the xls, and csv files were viewed perfect, but the dbf file had the same issues on the PC end. I must use the Mac because my variable software is for my Mac. Any ideas, Thanks

 

[John_McGhie_[MVP]]

He needs to save that file in Unicode (UTF-8) format.

Unicode is the modern character set that has enough characters (65,000-odd)
to have a separate character for each of the accented letters.

He's saving the file in ANSI, which can describe only 256 characters: not
enough.

When you open that file in Excel, the Text Import wizard should appear.
When it does, there is a "File Origin" box. If you change that from
Macintosh to "Windows" you might get away with it. Unlikely, with accented
characters: but worth a try.

Hope this helps

Version: v.X Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello,
I am having issues with PC data showing up the same on my MAC. My partner
generates a pre sorted data list from the customers original excel file. He
has given me the data in a .csv, .dbf, .xls fiel but I'm running into the same
problems with all 3 files. All the accents over the spanish names are being
transformed into different characters. Just for giggles I tested all 3 Files
on a different PC, and both the xls, and csv files were viewed perfect, but
the dbf file had the same issues on the PC end. I must use the Mac because my
variable software is for my Mac. Any ideas, Thanks

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]