excel - How can I convert .xls file to MySQL? -

excel - How can I convert .xls file to MySQL? -

my sample info column in xls is:

|numbers | 1 | 2 | 3 | | 1 | | b | c | | 2 |a.1|b.2|c.3|

i have table of in mysql table

|numbers | 1 | 2 | 3 |

i'm using code

load info local infile 'c:/a.xls' table mytable fields terminated ';' enclosed '"' lines terminated '\r\n';

my result becomes exceptional characters, how can total detail?

if have php knowledge can code script , utilize phpexcel library.

otherwise guess open xls in excel save csv , utilize load info infile query.

mysql excel xls