On 27.02.2001 12:00:38 wrote: > then i try the following and i get the error message. WHAT error message? > > load data local inifile "c:\text.txt" into table dbname.tblname fields > terminated by ',' ; Hmm, as you don't tell us the error message that you're getting, it's hard to help you. I don't know for sure, but maybe MySQL can't handle the DOS directory delimeter \ when it's unescaped? So, try "C:\\text.txt" instead of "c:\text.txt". Hmm, or maybe MySQL needs Unix style delimiters? Try "c:/text.txt". --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php