cpp导入excel到mysql,从excel导入数据到mysql

i am trying to import data into mysql database from excel.

i have installed mysql for excel 1.2

i typed the following command in mysql workbench nd got the following:

load data infile 'D:\\b.xlsx' into table trial;

output:

Error Code: 1045. Access denied for user 'gargi'@'localhost' (using password: YES)0.000 sec

when i typed the same in command client got the following:

mysql> load data infile 'D:\\Book1.xlsx' into table book;

ouput:

ERROR 1366 (HY000): Incorrect integer value: 'PK♥♦¶' for column 'age' at row 1

pl help me with this or suggest some other means to import data into mysql other than phpmyadmin

解决方案Check this approach

how-to-import-an-excel-file-in-to-a-mysql-database[^]

let me know it's working or not..