MySQL Forums
Forum List  »  Microsoft Access

Re: Importing Excel database into phpmyadmin - CSV compatibility
Posted by: Ed Close
Date: April 27, 2011 06:32AM

Thanks for prompt reply. I tried doing as you suggested but Im getting the following error. Can you advise?
Ed

SQL query:

LOAD DATA INFILE '/home/designer/tmp/php3PYAZi' REPLACE INTO TABLE `add_venue`
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'

MySQL said:

#1045 - Access denied for user 'designer'@'localhost' (using password: YES)

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.