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!!
Subject
Views
Written By
Posted
35379
July 20, 2004 11:41PM
21712
July 21, 2004 12:35AM
Re: Insert data from excel files to database table
11940
July 21, 2004 01:45AM
19405
July 21, 2004 02:54AM
12089
July 21, 2004 03:33AM
9313
July 21, 2004 04:54AM
7833
May 02, 2008 01:36AM
9876
December 09, 2005 07:52AM
5334
March 25, 2009 10:54PM
6475
June 22, 2006 07:29PM
6505
January 30, 2006 07:51AM
5456
November 08, 2008 02:28AM
5461
January 22, 2009 12:19PM
6231
February 24, 2009 03:23AM
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.