Are you using mysqlimport utility? If not that may be you answer? If so what flags are you setting?
david > HI ALL: Happy New Year ;) > I have a text file generated from MSAccess database, one of the > fields (Long Text) have Carriage returns within the text, So > the data of some records falls in more than one line in the > text file, when I'm using the SQL statement LOAD DATA INFILE... > I have only the first line of the data in this field, You know > the data in the file looks like : > 8|RO|The rates are applicabe for prepaid shipments only. > Other charges: Awb fees 230Syp, Handling 0.65Syp per KG, Stamp > 16Syp.|\r\n > 9|KL|Other charges: Awb fees 230Syp, Handling 0.65Syp per KG, > Stamp 16Syp, Security Charge 0.13Usd per Kg based on actual > weight of the shipment.|\r\n > 10|JU|Other charges: Awb fees 230Syp, Handling 0.65Syp per KG, > Stamp 16Syp.|\r\n > > Please Help > Best Regards > Hayan > > > > ________________________________________________ > Get your own "800" number > Voicemail, fax, email, and a lot more > http://www.ureach.com/reg/tag > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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