Error when importing excel data into my sql work bench
Error Code: 1300. Invalid utf8 character string: ''Database Mysql workbench
i am importing excel data into my sql work bench.
LOAD DATA local INFILE 'C:/Users/1900057/Desktop/Sql Query/sndata.xlsx'
INTO TABLE sample.clinicalsamples FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS
when i import shows error as follows
Error Code: 1300. Invalid utf8 character string: ''