如何将.xls中的数据加载到mysql表中

嗨！在那里我需要从.xls文件输入数据到MySql表，但是得到



我的excel文件：



id fname lname

1 test1 test1

2 test2 test2

Hi! there I need to enter data from .xls file to MySql table, but getting

My excel file:

id fname lname
1 test1 test1
2 test2 test2

Error Code: 1366
Incorrect integer value: '' for column 'id' at row 1

我错了，需要帮助。

提前致谢。



我尝试过：



LOAD DATA INFILE'D：/test.xls'

替换表格tetstbl

终止于'\t'的字段>
由'\ r'终止的线路

IGNORE 1 LINES;

Where I am wrong,need help.
Thanks in advance.

What I have tried:

LOAD DATA INFILE 'D:/test.xls'
REPLACE INTO TABLE tetstbl
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r'
IGNORE 1 LINES ;