Does anybody have a solution to this? I'm having the same problem. I've verified that eastern language support is installed on the server (it wasn't originally) and can see the Japanese and Chinese characters in the CSV text file. I can also copy and paste the characters into an Excel sheet. But once I try to import the data into either Excel or SQL Server 2005, it gets replaced with either squares or random characters.
Thanks!