I write a query to insert file data to a table as follows
LOAD DATA INFILE 'C:\Documents and Settings\Administrator\Desktop\Merge.txt' INTO TABLE tblachmaster
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
But this is giving me an error as
C:Documents and SettingsAdministratorDesktopMerge.txt not found can any one tell why
Member
113 Points
381 Posts
File not found error
Apr 21, 2011 08:47 AM|Dora743|LINK
I write a query to insert file data to a table as follows
But this is giving me an error as
C:Documents and SettingsAdministratorDesktopMerge.txt not found can any one tell why
Member
113 Points
381 Posts
Re: File not found error
Apr 21, 2011 10:19 AM|Dora743|LINK
Resolved it is because of instead of / i used \