Forgive me, I should have searched the archives first. Let me rephrase from what I have seen there: Do I understand that I should have my export routine Subsitute '\n' for newline ? Substitute '\t' for TAB ?
Thanks Again -tim- * Tim Johnson <[EMAIL PROTECTED]> [020415 15:13]: > Hello All: > I am using mysql 3.23 on Linux. I have a project in > what I will need to do the following: > First: export a MS-Access database to a set of > delimited text files, one for each table. > Secondly: Load each of those text files into a MySql Table. > > Since I am new to MySql, I am posing this question? > Exporting a Ms-Access Memo field (which can contain newline/carriage returns) > to a text file will mess up the structure of the delimited file. > In other case, I have used VBA to convert line endings to another character, > (ctrl-B or Ascii 2, as an example) > > Is there a way that I can use a newline substitute for export that > can then be converted back to the original newline when mysql loads > the text file? > > TIA > Regards > -- > Tim Johnson <[EMAIL PROTECTED]> > http://www.alaska-internet-solutions.com > http://www.johnsons-web.com > > --------------------------------------------------------------------- > 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 -- Tim Johnson <[EMAIL PROTECTED]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com --------------------------------------------------------------------- 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