Handling Memo Fields from MS-Access?
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
RE: Handling Memo Fields from MS-Access?
Hi .. Mysql's LOAD DATA INFILE will take newline character as the lines' terminating character, but you can always change by LINES TERMINATED BY clause. So, say you have | character as the line ending character in your text file, you can just add LINES TERMINATED BY '|' clause to your LOAD DATA INFILE syntax. See: http://www.mysql.com/doc/L/O/LOAD_DATA.html If you need to change some characters in the text file before loading it into the database just vi the file and make the necessaray changes thru global search/replace . Gurhan -Original Message- From: Tim Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 7:09 PM To: [EMAIL PROTECTED] Subject: Handling Memo Fields from MS-Access? 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 - 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
Re: Handling Memo Fields from MS-Access?/\t\n
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