MySQL Forums
Forum List  »  Other Migration

Re: Insert data from excel files to database table
Posted by: yilinglim
Date: July 21, 2004 01:45AM

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!!





Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.