Click here to Skip to main content
15,886,518 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Updated 6-Feb-14 23:11pm
v2

1 solution

Check this approach

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

let me know it's working or not..
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900