Re: Insert data from excel files to database table

[yilinglim]

there is password for my database..

so when i try to -->
load data infile 'abc.csv' into table xyz;

it prompt me an error msg !!
Error 1045: Access denied for user : 'db@%' (using password = yes)

so..what can i do now ???

i tried this command before... but it also failed!!

> /op/mysql db < 'abc.csv' -u db -p
then it will prompt --> Enter password

this command is failed for me to load the data in .csv but success if the file is saved in .txt and all the insert query ready inside!!