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
