There are many tables that I store them in XLS form. Many columns of these tables are stored data by using DBCS -- Big5.
Is there any way that I can import datas from those XLS files into MySQL tables?
Because the "\"--0x5C is a part of many Traditional Chinese characters in BIG5 code set. So I can't use such as "mysqlimport" utilities to import data from XLS to CSV to Mysql. Or do I miss some options when I use mysqlimport?