Error: 13 - Can't get stat of (Errcode: 2)
Hi, does anyone know how to import a text/CSV file into database table.
I have created a text file and try to import the file content into a table. However, I got the these error...
my file contains (1,1,Alan)
LOAD DATA LOCAL INFILE 'C:/My Documents/boe3004.csv' INTO TABLE fidu.BLIST_NOFRAUD FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (FILE_REF_NO,FILE_ENCL_NO,NAME)Error: 13 - Can't get stat of 'C:/My Documents/boe3004.csv' (Errcode: 2)
I am using MySQL version mysql-3-23 .
Your help will be very appricated.